Home » Developer & Programmer » Forms » OLE2 updating excel file from Forms question (Oracle Forms 6i Windows platform)
OLE2 updating excel file from Forms question [message #535177] Mon, 12 December 2011 10:14 Go to next message
katiush
Messages: 2
Registered: December 2011
Junior Member
I am using OLE2 to update an excel spreadsheet from Oracle Forms 6i. If the excel spreadsheet is already open, the code runs through fine, and even asks if you want to replace the file when running the lines: OLE2.INVOKE(worksheet, 'Save');
OLE2.INVOKE(workbook, 'Save');

However, the file never gets updated. There is no error that appears.
I would like to have the program check if the file is open before running the program; can anyone offer advice as to how to do that?

Thanks,
Katia

Report message to a moderator

Re: OLE2 updating excel file from Forms question [message #535178 is a reply to message #535177] Mon, 12 December 2011 11:05 Go to previous message
katiush
Messages: 2
Registered: December 2011
Junior Member
Update: I have discovered that the file is actually saved in a different location, in My Documents, which is strange.

Report message to a moderator

Previous Topic: Progress bar not working...
Next Topic: Icons in weblogic 11g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 10 07:04:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.