Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_open option
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_open option
Aaron,
If ThisWorkbook.name = "Schedule Master" then 'download code here endif hth, Doug "Aaron" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dont have secondary axis option listed in Series Option | Charts and Charting in Excel | |||
preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option. | Excel Worksheet Functions | |||
Option Commands (Option Explicit / Option Base etc) - Scope | Excel Programming |