Good Morning,

I am working on saving excel objects to a directory of my choosing. I am able to use a folder browser dialog to select the save location and the saveas method within the excel interop and i am able to create a file in the folder i select with the name i choose.

The issue is that when i later go to open that file it is blank. no workbooks no worksheets etc . Just a seemingly blank file in the proper location with the proper name.

It should be noted that if i single click on the report icon to open it the microsoft browser window does show a tiny preview of what seems like the correct report.




Code:
eapp.Worksheets(1).SaveAs(FileName:=patient_frm.savefolder & "\Lateral Postural Analysis")