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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Look in the ThisWorkbook module for the Workbook_Open event. Put in there.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Multiple CSV Files from Same Folder into Open Workbook 5
Merge Multiple workbook sheets into one workbook 0
Macro to push data to another workbook 0
Opening a Workbook with a Macro 4
How to create absolue path link to another workbook (Excel 2003) 1
Move/Copy Worksheet with Macros 2
Run a macro from another workbook in the QAT 1
Open csv file with Leading Zeros 1

Back
Top