Can I set a macro to run each time a workbook is opened?

P

Paul Leslie

I am importing data from a CSV file to an SPC database.
When the CSV file is closed, an Excel workbook opens and displays a button
that imports the inspection data and closes the workbook when selected.
Sometimes the employees forget to select the button so after another
inspection, another copy of the workbook tries to open.
 
P

Paul Leslie

I am new at this.
The code that opens the workbook is...

Shell "C:\Program files\Microsoft Office\Office\excel.exe
C:\MPP\Company\Product\Other_Files\Product.xls"

Is there a delimiter I should use with the last line?
 
Top