Auto run macro on *.csv file open
What process is opening the csv file? Where does it open - in Excel ?
Tim
--
Tim Williams
Palo Alto, CA
"CP Poe" wrote in message
...
I have a *.CSV file that opens/updates information for part measurements.
Current macros have previously closed all but the Personal macro workbook.
When a new part is measured, and it's data sent to the CSV file, I need a
method of automatically running macros when this CSV file opens. The CSV
itself will not store a self-start macro, either due to Excel constraints,
or
due to the setup of the sendig program. Can someone help me set up a
macro
in the Personal workbook that will begin after this specific CSV opens? I
am
using Excel 97.
Thank!
--
CPPoe
|