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?
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,900
Messages
5,471,388
Members
406,759
Latest member
jackflint

This Week's Hot Topics

Top