Automatically enable l macros

[krissz]

I have an Excel2003 workbook which collects & summarises data from nearly 100 individual CSV files. For ease of use, macros are used to help navigation.

The CSV files are updated every night. I want to also update the workbook automatically every night. Is there a way in VBA to 'Enable' macros so that the workbook updates automatically ?

All operations in relation to updateing are run on my personal PC

 

[Joe4]

If you could use Macros to Enable VBA, that would be a huge security concern, as people could write malicious viruses and force your computer to run them! Thanks goodness that is not possible!

If the issue you are having is you are trying to bypass the security warning prompts, there are a number of things you can do:
1. Lower your security level to allow all macros/VBA (not recommended for security reasons)
2. Digitially sign your macro, then set that computer to accept all macros from that user
3. Add a Trusted Location to that computer, so it will automatically enable all macros from files in a certain specified location on your network/hard-drive

 

[krissz]

Thank you for the advice. 2 & 3 plus other info on security have helped me to resolve this