Blogs from Wise Owl on FileSystemObjects in VBA macros

Showing blogs 1-4 (out of 4)

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!