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.Windows.Count).Visible = True