Vba macro to open workbook and then activate the workbook from which the macro wss started

[Vbanoob98]

I have 1 macro that I use on different workbooks to pass data into a fixed workbook.

So I want to be able to open that fixed workbook and then run my copying macro from the changing workbooks. The problem is when I use vba to open the workbook it makes it the active one and the macro copies the data from the fixed workbook.

Any help would be really appreciated.

 

[Vbanoob98]

Found the solution. Call this first then my other macro

Sub OPEN1()
 Dim wb As Workbook, currentWb As Workbook
    Set currentWb = ThisWorkbook
    Set wb = Workbooks.Open("file")
    ' if you want to close opened workbook
    'wb.Close
    ' if you want to bring to front original workbook
    currentWb.Activate

End Sub​