I am currently using the Oracle Business Intelligence Spreadsheet Add-in 10g, version 10.1.2.3, to log into Discoverer OLAP. I am able to save my changes to the database by logging in with the Read Only option unchecked and by clicking the Save button. When I click the Save button a message pops up asking if I would like to save my data change to the Oracle database.
What I would like to do is create two separate macros where one macro performs the file save and the other macro saves the data to the Oracle database. I am unable to find any code that performs the actual saving to the databse and it appears that the actual save action (ActiveWorkbook.Save) triggers the pop up to confirm the save to the database.
Is it possible to separate the Saving steps? Can this be achieved through a macro?