Macros with multiple workbooks open

[gbullr]

Suppose I have two workbooks open. In one (File1) I have a macro that runs every x minutes and a sheet called sheet1. In the other (File2) I have other macros but not a sheet called sheet1. If my active workbook is File2 but the macro that runs is the one from File1 I will get a runtime error for obvious reasons. Is there a way to have the macro that runs every x minutes to run ONLY on File1?

I could do if ThisWorkbook.Name <> "File1.xlsm" then ____

What is the code that makes File1 the activeworkbook.

Thank you.

 

[craig.penny]

Try something like this

Dim s As Workbook
Set s = ThisWorkbook

Then when you refer to a sheet name you would use

s.Sheets("YourTabNameHere")

Does that answer your question?

 

[gbullr]

If there is only one file open it works fine because the macro only runs on that one file. When I have two files open and I am working on the other file w/ the macro working in the background it runs on the file that I have active and consecuently gives me a run-time error.