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.

 

[alansidman]

Your request is to general to offer a solution. How about some specifics.

 

[Sahak]

Thank you Alan for reply.

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. The problem is that next time source file will have different name, let say “Items-62.xlsx”, so it will be not good idea each time to make source file name changes in macro. I need macro which will activate any file with different names with same macro.

 

[shg]

When you open it, assign a workbook variable

set myWkb = workbooks.open(whatever)
...
myWkb.activate

 

[Sahak]

Hi SHG.

Thank you very much for reply.
Am I Missing Something Here? Here is my code:

Sub Activate_OtherBook()
    Set myWkb = Workbooks.Open(whatever)
    myWkb.Activate
End Sub

Im getting Run-time error ‘1001’:
“ could not be found. Check the spelling of the file name, and verify that the file location is correct.

 

[shg]

Are you opening the workbook in code?

 

[Sahak]

Yes, I think i misunderstand your "When you open it, assign a workbook variable"

 

[shg]

Post the code you're using to open the workbook.

 

[Sahak]

Sub Activate_OtherBook()
    Set myWkb = Workbooks.Open()
    myWkb.Activate
End Sub

 

[shg]

That's not the code you're using -- it doesn't compile.