BY TOPIC
EXCEL / VBA BLOGS
VBA MACROS BLOGS
- Recording macros (1)
- Working with ranges (4)
- Input/message boxes (3)
- Variables, arrays (3)
- Enumerations (2)
- Loops and conditions (2)
- Errors and debugging (2)
- Functions / arguments (3)
- Events (2)
- User forms (6)
- Classes (4)
- References (9)
- Files and folders (4)
- General (12)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Files and folders 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
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
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
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
In order to work efficiently with files and folders you first need to create a FileSystemObject. This blog explains how to do this!