Hi
You can find VB code to invoke the File Open / Save dialog boxes. They need to be tweaked to VBScript for it to work in ASP.
If you can get the reference to the Excel workbook object in the lower frame, then you can save it using the syntax:
Activeworkbook.SaveAs filename:=Application.GetSaveAsFilename
(This is the VB Code)
In VB Script, you need to define the Excel Application and Workbook objects using CreteObject and then call the corresponding methods.
Dim oExcelApp ' excel.Application
Dim oWs ' excel.Worksheet
Dim oWb ' excel.Workbook
Dim strFileName ' String
Set oExcelApp = CreateObject("EXCEL.APPLICATION")
Set oWs = oExcelApp.ActiveSheet
Set oWb = oExcelApp.ActiveWorkbook
strFileName = <Filename used when opening the Excel file>
oWb.SaveAs strFilename
(You must set a reference to Excel in the Project | References dialog)
Refer to the following link for an idea on how to use the Excel Application object.
http://msdn.microsoft.com/library/d...tml/deovrworkingwithmicrosoftexcelobjects.asp
You could use the same filename you used to open the excel sheet while saving to the local system too. Once the file is saved, redirect the control to FileUpload page and pass the name of the file (and path if needed) for it to upload the same.
In VB its possible to invoke the SaveAs dialog but I am not sure if we can do that in VBScript by replacing:
strFileName = <Filename used when opening the Excel file>
with
strFileName = Application.GetSaveAsFilename (You could give it a try)
Hope this helps
SPA
