vba to capture file name

[tuktuk]

hey there...

i have 2 workbooks open.....

if i use the following vba code

strFileName = ThisWorkbook.Name

i capture the name of the file that I DO NOT want .

what is the easiest way to string the other workbook name?

T

 

[ChrisM]

The easiest way is to be proactive. As you note, you can really only grab the name of the active workbook. So grab and store the first workbook name, then when you open the second workbook, it becomes the active book, and you can grab and store that one.

If both books are opened before your code even runs, then all you can do is loop through all the open workbooks and parse out the names you want/don't want.

Dim wrkbk as Workbook

For Each wrkbk in Workbooks
    wrkbk.Name = myvariable
Next wrkbk