get the name of the first workbook that opened this workbook

[carsto]

Workbook A is not mine. Workbook A has an Author but a different current user.

Workbook B is mine.

Workbook A code opens workbook B, loads data to B and INITIATES code IN Workbook B to make calculations in and save Workbook B.
I want to capture the Author (not the current user) of Workbook A. I don’t know the name of the file.

How do I capture the name of Workbook A that opened my workbook B so I can get its Author?

I can only add code to my own Workbook B.

[BellyGas]

Somewhere in your code you can tell your macro to save the author name of all open workbooks.

You'll have to loop through all open workbooks storing the name of the workbook (.name) and the author (.BuiltinDocumentProperties("Last Author"))

It's referred to in code like: thisworkbook.name or thisworkbook.BuiltinDocumentProperties("Last Author")

so something like

Please Login or Register  to view this content.

You'll then have to use your own judgement as to which workbook / author is correct. The issue is you don't know how many other workbooks are open on the PC of the fella who opens workbook A. I'm assuming you also don't know the name of workbook A.

[mikerickson]

If you put this in the ThisWorkbook code module of WorkbookB, it will capture the workbook the is active when WorkbookB is opened.
That workbook may or may not be Workbook A. (One can call a macro from a non-active workbook)

Please Login or Register  to view this content.

Code like this will return the author of that workbook

Please Login or Register  to view this content.

[JOHN H. DAVIS]

If Workbook A is the only file that is open first maybe you can get the name using this.

Please Login or Register  to view this content.

You code would have set wbk before it opens Workbook B. You could also use activeworkbook in place of Workbooks(Workbooks.Count) which would be the last workbook opened.

[carsto]

PreviousWB is exactly what I wanted

Thanks a million!

If you put this in the ThisWorkbook code module of WorkbookB, it will capture the workbook the is active when WorkbookB is opened.
That workbook may or may not be Workbook A. (One can call a macro from a non-active workbook)

Please Login or Register  to view this content.

Code like this will return the author of that workbook

Please Login or Register  to view this content.