How to have a text file impoted on startup

G

gyro2222

I have a workbook which plots graphs saved by a comma delimited file, which I
import.
i would like to have this happen automatically each time i open the
spreadsheet. the imported file always has the same name: export.txt
i createda a macro which i gave a shortcut of ctrl Q. This works OK when I
do this manually.
Thanks
Hal
 
B

Bob I

From the Help files:

Automatic macros, such as Auto_Open, are designed to run when you start
Excel. For more information about these macros, see Microsoft Visual
Basic Help.
 

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

Top