workbook_open option

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

Guest

Hi,

I have a file named Schedule Master.xls in which I manipulate and save as a
name+date.xls. When I open the Schedule Master, I have code to automatically
import a new set of data. However, if I need to open my name+date.xls files
in the future, I want to use the data already there...NOT download new data.

I'm wondering if I can enter code on the workbook_open event that will look
at the name of the file. If it is named Schedule Master, then run download
macro. IF it is not, then nothing. Any help and/or other ideas would be
wonderful.
 
Aaron,

If ThisWorkbook.name = "Schedule Master" then
'download code here
endif

hth,

Doug
 

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

saving And rename source file 1
GetOpenFilename code execution interrupted 5
Unable to change ActiveSheet within Workbook_Open 2
Preventing workbook_open code executing. 2
Macro code that will look for the most recent workbook 3
Ribbon Button not Working with my Referenced Workbook 2
Workbook_Activate() vs Workbook_Open() 1
Schedule downloads in VBA 5

Back
Top