Hi, I need help in saving an embedded excel file within an OLE control.
The excel workbook has a SAVE button and macros to save excel worksheets. When the user clicks on the SAVE button (within the EXCEL), it makes a copy of 3 worksheets within the current workbook and opens up the windows 'SaveAs' dialog box, where the users can specify the directory where they want to save the file.
The above process works fine if the excel is stand alone. However, if I embed the excel in an OLE control and click on SAVE button, I am getting an runtime error 'Method SaveAs of Object _workbook failed'. Pls give pointers on solving the error.
Also, I am open to any suggestion of changing the entire process if need be. All I need is the users should be able to access the excel file thru PB application (only PB, no stand alone) and should be able to save the file to their C:\ drive. Last but not least, it is a multiuser environment and the application will be put in CITRIX.
thanks -pasu
The excel workbook has a SAVE button and macros to save excel worksheets. When the user clicks on the SAVE button (within the EXCEL), it makes a copy of 3 worksheets within the current workbook and opens up the windows 'SaveAs' dialog box, where the users can specify the directory where they want to save the file.
The above process works fine if the excel is stand alone. However, if I embed the excel in an OLE control and click on SAVE button, I am getting an runtime error 'Method SaveAs of Object _workbook failed'. Pls give pointers on solving the error.
Also, I am open to any suggestion of changing the entire process if need be. All I need is the users should be able to access the excel file thru PB application (only PB, no stand alone) and should be able to save the file to their C:\ drive. Last but not least, it is a multiuser environment and the application will be put in CITRIX.
thanks -pasu