set vba to interact with set instance of excel

[dantheman9]

My code runs fine, in terms of an automatic update on time every xx minutes or so, the problem is, if I have two excel windows opens, it copies data to which ever on is selected at the time of the update. I there a way to tie code to the instance of excel that is selected at the time of launching the code?

 

[mikerickson]

It sounds like your routine uses unqualified references.
Use syntax like

Workbooks("Workbook1.xls").Sheets("Sheet1").Range("A1").Value = 3

rather than

Range("A1").Value = 3

 

[dantheman9]

Hi Mike,

thanks for getting back yes it does at present, would it work in terms of setting the workbook name as a varaible? (So the vba code is all on a userform, which is activated by an open/close option in excels ribbon).
Something like

Public Name as Workbook
 
Sub open ()
 
Set Name as Active Workbook
 
blah
blah
End Sub

 

[mikerickson]

Something like

Dim myWorkbook as Workbook

Set myWorkbook = ActiveWorkbook

myWorkbook.Sheets("Sheet1").Range("A1") = 3

or perhaps

Dim myWorksheet as Worksheet

Set myWorksheet = ActiveSheet

myWorksheet.Range("A1") = 3

If the download always goes to the same workbook that holds the code for the UF, you could use ThisWorkbook rather than ActiveWorkbook.