Automatically save Excel file in static form

[sunnywink]

Hi all,

I recently constructed an Excel file with query properties, which does queries from an Access database on a common drive.
The Excel file is set to do automatic query upon opening; and there is a prompt window for us to key in a reference criteria to query whenever we enter this file.

However, when I try sending this file though e-mail, the recipient also sees the prompt window when they open the file.

Anyone has idea how can I avoid the E-mail recievers from being prompted to prevent unnecessary clicking in order to cancel the prompt.

Can I maybe save the file as a static form automatically to another file name such that the query is disabled before the e-mail is sent out?

Many thanks in advance.

 

[kylua]

Put a radio button on the spreadsheet which toggles auto query on and off. Switch it off before you save to send. Just check the value on before running the open macro.
This does necessitate resaving after you sent it if you want it to auto query next time you open it.
You could try only doing the query if it is opened by certain usernames.
Otherwise, you can create a new workbook, write the info to it, save and send that.

 

[PaulTEG]

You could try saving as HTML, or write your own version of a HTML document

Mebbee?