OLE Excel Workbook hidden after Extraction from Notes document

HCL Domino Domino Forum
1

Hi,

Tried to extract Excel Objects from Notes documents to local drive. The code at http://h30499.www3.hp.com/t5/HP-Records-Manager-HP-TRIM-Forum/Lotus-Notes-Integration-Exporting-ole-objects/td-p/4267279 allowed me to export the Excel files but the workbooks are hidden. Need to open up the extracted Excel files and unhide the workbook, then save it again.

Please advise what code could be put in to unhide the workbook automatically?

The code below doesn’t do the job:

'** this is so Excel spreadsheets don’t end up being hidden

oleObj.Application.Windows(oleObj.Application.Wind​ows.Count).Visible = True

2

Subject: Wicked old code

That code is from 2003:nsftools - Lotus Notes and Domino Tips

It’s entirely possible that the MS OLE model has changed a bit. I’d recommend checking with some MS Excel forums and see what you can find out since the code you reference mostly uses MS code constructs rather than LS.

If/when you get something, post here and see if Julian might want to update his stuff.