Excel VBA Files and Folders
Using the links to the following resources, you can learn all about Excel VBA Files and Folders.
- Determining the Current Directory
- Using sequential access
- Macro to Change File Type to All Files (.) in Open Dialog Box
- Cleaning up those non-printing ASCII characters after a text import.
- FileSystemObject (FSO) – File List
- Getting Rid of Extra Quote Marks in Exported Text Files
- Delete files and folders
- Determining When a File Was Created
- Inconsistent Output for Empty Columns in a CSV File
- How to open a file from VBA
- How to Programmatically Display All Files in a Folder
- Loop Through a Folder of Excel Workbooks
- Read a Text File with VBA, And Write the Text to Excel.
- How to Convert All Files on a Server to Microsoft Excel
- Using binary access
- Basic file and folder examples
- How to Work with Random Access Files
- How to Use System, User, and File Data Sources
- Select file or folder names in Word
- Retrieving Drive Statistics