Search results

It appears to be a path problem. I removed the path, .SaveAs("ComponentList.xlsx") I am working on a virtual destktop and the workbook is saved to my user directory. SO I can make it work for me, but not for others unless I can figure out how to catch the path to use later.

Thanks, Doc_Man. I had seen a couple of those but I am finding them not helpful. If I comment the .SaveAs, I can run it over and over, being prompted each time on whether to save Book1 when .Close executes. I do save it and it opens fine. I checked Task Manager, and there is only one instance...

I am getting puzzling error when attempting to use VBA to create and save an Excel workbook. (I have searched the forum diligently.):banghead: All works fine - I have been able to create and view the workbook - but the SaveAs generates the attached error. It appears to be generating a hex file...