I'm writing an application and was thinking about using a FileSystemObject to manipulate a file. When I use it I get a runtime error. After googling the problem, it seems I need to ..
To use FileSystemObject you have to use a special reference which tells Excel where it can find out what FileSystemObject is.
In the VBA IDE, go to Tools > References
Tick "Microsoft Scripting Runtime" and click OK
My question is, if I want to role out my application, will the end user need to mess around with the VBA IDE to get it to work?
The idea is to deploy the application as an VBA Add In