How to switch between windows in Excel when the path is referenced in a Excel cell?

Hi Guys, I have an Excel Macro which opens a spreadsheet in the Cell "F7", then copies and pastes to another spreadsheet. See the code below. However, when I go Windows -> (so to return to the spreadsheet) how do I adapt it in the code?

Sub Macro9()

Workbooks.Open Filename:=Range("F7")

Sheets("CV").Select
Cells.Select
Range("A17").Activate
Selection.Copy
Windows("01 - EMEA Mortgages Reporting Pack - Jan 15 (B) Test.xlsm").Activat

Microsoft ExcelSpreadsheetsVisual Basic Classic

Last Comment

Rory Archibald

8/22/2022 - Mon

Saurabh Singh Teotia

2/26/2015

Sub macro9()
Dim wb As Workbook, wb1 As Workbook

Set wb = ThisWorkbook

Set wb1 = Workbooks.Open(Range("F7").Value)

    Sheets("CV").Select
    Cells.Select
    Range("A17").Activate
    Selection.Copy
    
    wb.Activate