Save Opened Excel Files

[newuser1234]

Hey folks,

I am needing to save an opened Excel file, but the issue that I am running into is that this instance of Excel won't have been opened via the Excel UDF.  I am exporting data as part of a web scrapping process I'm working on, and the data is put into a Excel file from my browser. Is there a way to simply attach an open Excel file to an Excel object in       AutoIT so that I can then use the Excel UDF to manipulate it?

Thanks in advance.

[AutoBert]

Try _Excel_BookAttach

[newuser1234]

Yeah that was what I have been attempting, but every example that I've found using _Excel_BookAttach was using a file that has already been saved, and the file is referenced by file path. When I export my scrapped data, it simply opens a new query in Excel and downloads it within the work book, but the workbook  has not been saved.  If I could just figure out how to script the saving of this workbook, I should be set as I have some VBA code that can handle everything else that I need to format my datasets. Am I able to use _Excel_BookAttach in this manner? 

[water]

_Excel_BookAttach allows to attach by "Title - Title of the Excel window" as well.