Advanced VBA exercises on FILESYSTEMOBJECTS

This page lists the 4 exercises about FileSystemObjects in Advanced VBA on our website:

Software: Advanced VBA
Version: Any MS Office versions
Topic: FileSystemObjects
Level: Relatively easy
Course: Advanced VBA
Exercise: Write a macro which creates a FileSystemObject reference, then uses this to list out all of the Excel workbooks in a folder.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: FileSystemObjects
Level: Average difficulty
Course: Advanced VBA
Exercise: Write a macro to open lots of workbooks in turn, collating the responses from each.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: FileSystemObjects
Level: Average difficulty
Course: Advanced VBA
Exercise: Using FileSystemObjects to move, copy, rename and delete files and folders.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: FileSystemObjects
Level: Harder than average
Course: Advanced VBA
Exercise: Consolidate data from files on your computer using file references.

Go to exercise ...

You can search our full list of VBA exercises here, or why not have a look at our other VBA training resources?

This page has 0 threads Add post