Importing macros into Excel

N

NikRoberts

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
 
D

Dave Peterson

See one response at your other post.

NikRoberts < said:
Hi,

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

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

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

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

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

Please please help.

Nik
Click to expand...
 
Top