Automatic Macro execution

J

John Gilchrist

I have a DATA.CSV file with numerical data. I wish to view this data, using
a chart and macro which is located in a different COIL_VIEWER.XLS excel
file.

Is there a way to open the DATA.CSV file, and automatically execute the
macro which is located in the other file (COIL_VIEWER.XLS) without any
operator intervention??

Thank you,
JOhn
 
H

HansM

Probably want to stick the macro in "personal.xls" and then people could
open that CSV file with a click of a button on the tool bar. No programming
required. Just record keystrokes.
 
Top