View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CP Poe CP Poe is offline
external usenet poster
 
Posts: 3
Default Auto run macro on *.csv file open

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