Hi All,

Iam calling Excel page in ASP using VB Script. After the Excel page is
loaded I want the user to SaveAs in different path.
How can I do it.

any help would be glad asap.

rgds

Ramesh

Ramesh

Not sure how your interoperability is working but Excel has a
WorkBook_BeforeSave() event that can detect if the user presses SaveAs as
opposed to Save. You can then stop the save and advise.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI = False Then
MsgBox "You must use save as NOT save", vbExclamation + vbOKOnly
Cancel = True
End If
End Sub

Alternatively, your Excel file could be saved as a template (*.xlt). This
will always only allow a SaveAs

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


wrote in message
oups.com...
Hi All,

Iam calling Excel page in ASP using VB Script. After the Excel page is
loaded I want the user to SaveAs in different path.
How can I do it.

any help would be glad asap.

rgds

Ramesh

Hi Nick,
thanks for the info, but my question is..
I want to show the user the Dialog box of SAVEAS when the excel is
loaded.

rgds

Ramesh

Ramesh
Application.Dialogs(xlDialogSaveAs).Show
or
Application.Dialogs(xlDialogSaveCopyAs).Show

NickHK

wrote in message
oups.com...
Hi Nick,
thanks for the info, but my question is..
I want to show the user the Dialog box of SAVEAS when the excel is
loaded.

rgds

Ramesh