Hi,

I have been doing some work in UNIX. The results come out as a larg
.csv text file (delimited by a comma).

To look at the results I like to import it into EXCEL. When I get int
Excel I have to format the report alot so I craeted a macro which I ca
run each time. Still no problem.

Because the csv file changes regularly this means the macro has t
change so I decided to create the macro's visual basic command
automatically whilst doing my work in UNIX and store them in a tex
file (macrofile.txt).

Everythings still going well and now I can manually open the .csv i
EXCEL and manually import the macrofile.txt into the Visual Basi
editor and then run it. Thats great manually.

So my question is how can I automate the openning of the .csv with th
macrofile.txt and then run the macrofile? (Tried recording my action
of imprting the macro but it does not work - as you can see I'm prett
new to this).

Please please help.

Ni

--
Message posted from http://www.ExcelForum.com