Activate other open excel file

[Sahak]

Hi all,

Macro to activate other open excel file which each time can have different file names.

Thank you in advance.

 

[Sahak]

Can you please give Code example?

 

[shg]

I'm asking what you're doing now, Sahak.

 

[Sahak]

Dear SHG,

I’m sorry for giving you hard time, the reason is my English is no good enough.
What I need is to take from open but not active Excel file some data & paste to master file.
Let say my master file name is “Master.xlsm” & it is active. There is another source excel file with name “Items-2021.xlsx” which is open but not active. I would like activate this file & take some data from it. In this case I know source file name & I can use in macro that file name to activate it, but next time source file will have different name, let say “Items-62.xlsx”, so it will be not good idea each time make source file name changes in macro. I need macro which will activate any Excel file with different names with same macro.
Thanks again for your help & patient.

 

[shg]

Right.

How can the code know which workbook to activate? Is it the only other workbook that's open?

 

[Sahak]

Can it look for some word in the beginning, in this case "Item_" * & ".xlsx" ?

 

[shg]

Sure:

Sub Sahak()
  Dim wkb As Workbook
  
  For Each wkb In Workbooks
    If LCase(wkb.Name) Like "item_*.xlsx" Then
      wkb.Activate
      Exit For
    End If
  Next wkb
  
  ' carry on ...
End Sub

 

[Sahak]

YES !!!!! you did it. Thank you VERY much & god bless you.

 

[shg]

You're welcome.