Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

FileSystemObjects in VBA blogs

Copy, rename, delete and move files and folders

Posted by Andy Brown on 23 January 2012 | 1 comment
By referencing the unintuitively named Microsoft Scripting Runtime object library you can write VBA code to access files and folders on your hard disk. This blog explains how, and gives a couple of worked examples.

Reading and writing to/from a text file using TextStreams

Posted by Andy Brown on 13 January 2012 | 2 comments
The easiest way to work with text files in VBA is using TextStream objects - this blog explains how they work.

How to choose files and folders in VBA

Posted by Andy Brown on 13 January 2012 | 1 comment
To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.

Linking to the Microsoft Scripting Runtime library

Posted by Andy Brown on 13 January 2012 | no comments
In order to work efficiently with files and folders you first need to create a FileSystemObject. This blog explains how to do this!

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.