Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Data Questions
I have a few questions:
I have a number of spreadsheets which contain queries to external data (the data source are text files located on the local machine). I am using Excel 2000 on Windows2000 machines. 1) If I have a macro that executes on Workbook-Open does the macro execute before or after the query? 2) If the query executes before, is there a way to prevent the query from executing until the macro runs? 3) When a spreadsheet containing an external data query is opened, a dialog box is popped up prompting the user to select 'Enable Automatic Refresh' or 'Disable Automatic Refresh'. There is also a check box that when selected chooses automatic refresh and no brings up the dialog box when the file is opened again. How can I bring back that dialog box once the check box is checked? Thanks for the help. Pete... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Importing Data Questions | Excel Discussion (Misc queries) |