View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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