hi...

need some expert help. i am open an excel file with a simple link as "<a ="file:///c:/inetpub/wwwroot/test.xls">"

no problem with this.
it opens in the same window (same explorer window) as my asp form is. This is what i want so this is not the problem!
What happens is that when i open the excel workbook i have some data being retrieved from the database and later when the user inputs some values inside it and clicks button "SAVE" inside it i will save it in the database directly thru vba code.

when i simply click the link and open the workbook and i click back button it gives an informative message as:
"the document has been modified.Do u want to save the changesHg
yes: save your changes
no: discard your changes
cancel: keep this document open.

i simple want to supress this error message?? how can i do that?
i am using asp as the web langeuage

thanks a lot

Hi

Please let me know when you get the answer

I have the same problem. I dont want the users to have that question. it is already done at the back end.

Thanks a lot in advance



Captain Jack Sparrow

Personally whenever you retrieve data, I'd do "ThisWorkbook.Saved = True" as the last command... but it sounds like it loads table data at open. If this isn't a routine that you can insert a command into, try putting this routine in the ThisWorkbook object module:
-----------------------------------------------------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)

'Makes the application think that changes to the workbook have been 'saved' just before closing.
'USE CAUTION DOING THIS, WILL NEVER PROMPT TO SAVE CHANGES if done before close!
  ThisWorkbook.Saved = True

End Sub
-----------------------------------------------------------------

Be careful where you set this... the prompt for save after changes feature is to protect the user from loss of data which can equate to hours of work.

Hope this helps.