P
Pete Tringale
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...
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...