Can excel run a text file as a macro?

martintallett

New Member
Joined
May 3, 2004
Messages
5
I have a Unix server that generates an Excel macro to load a file and then format it. The excel macro is a text file called anything you like ... the data file is a CSV file with a similar name but .CSV... Is it possible to persuade Excel to automatically run the macro contained in a text file without having to go through the process of manually loading and running the macro file?
 

martintallett

New Member
Joined
May 3, 2004
Messages
5
Thanks Nate, I can see how that would work. The only thing I am missing is a code fragment for a file dialog box in VBS !! :confused:
 

martintallett

New Member
Joined
May 3, 2004
Messages
5
Scrub my previous request :eek: no need for a file picker ... just run the text file as a VBS like you said . Hmmm Thanks again.
 

Forum statistics

Threads
1,078,253
Messages
5,339,105
Members
399,278
Latest member
randomNumberGenerator2211

Some videos you may like

This Week's Hot Topics

Top