Running a macro in a generated/unsaved WorkBook

[bibu]

Hi. Just a question, not a real problem.
How do I go about running a macro in an unsaved workbook that is generated by a software program? The workbooks as they are generated will have a name like "Book1", "Book2","Book3", etc. This is the name they get as they are generated and they are unsaved.
I have tried and it's impossible to refer to the workbook from a macro since generating the workbooks starts another EXCEL process.
Is there a way to create a macro that can run in ANY open workbook? It will just do a simple thing, save the workbook with the name :

Please Login or Register  to view this content.

Thanks for any advice.

[davesexcel]

Not sure what program you are using to create the workbook.

With VB Script, you can run a macro from a closed workbook.
Possibly the software you are using can run a macro from a closed workbook.

This code will run without opening the workbook, it runs the macro Button1_Click and it is located in Module1

It is a text file and would be saved as .vbs

Please Login or Register  to view this content.

2-11-2016 3-44-36 AM.jpg

Please note:
I do not use VB Scripts, I just know they exist, and that this sample is the only one I have ever tested

[bibu]

Thanks for your answer Dave. I haven't worked with VB scripts either, but to be honest I don't see this working. As I mentioned, the workbooks are unsaved(they have never been saved), so they are just "open" and they don't have a path to refer to. There will be around 60 workbooks open that need to be saved with the name in each workbook sheet1 "C1" value. Saving each workbook manually so it has a path is what I am doing now, which is quite tedious.

[davesexcel]

You haven't indicated what program you are using to create the workbooks.

[bibu]

No, I haven't because I didn't think it was of any consequence. It's not a popular software, it's basically an Access database that has a user interface to filter the data, and an option to export the filtered data to Excel.
In any case, I think my problem is very hard to solve in Excel, so I will look into an option to automatize this via other kind of macro recorder, not related to Excel. I will record the actions needed to save the file and go on from there. Thank you for your time.