Get All Open Excel Workbook Names 1

[traveller4]

Is there a way to get all open workbook names using VBA.

Currently I have an Excel Workbook that is distributed to users that updates a workbook kept on the user's workstation. My problem is some users workbook's are not the required workbook name and the users never keep the workbook in the required directory. I would like have my update workbook run its macros against their workbook irregardless of the name. I would like to pass the name of their workbook as a variable into the procedures in the update workbook.

Thanks in advance

 

[PHV]

A starting point:
For Each wb in Workbooks
MsgBox wb.Name
Next

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[traveller4]

Thanks a million PHV

That was exactly what I was looking for.


Thanks again