Open an Excel File using Macro

[HayabusaPR]

I would like to Open an Excel File using Macro that can read the path of the file that is located in Sheet1 Cell 7 Column 2 and the file name is in Cell 6 Column 2.

Thanks

 

[Logit]

.

Option Explicit


Sub opnOtherBook()
    Workbooks.Open Sheet1.Range("B7").Value & Sheet1.Range("B6").Value
End Sub

 

[HayabusaPR]

Thanks it works

 

[Logit]

You are welcome.

 

[HayabusaPR]

additional questions: I need to copy columns A-C from the file that opened and paste it in the Macro file Sheet2 from column A-C

 

[Logit]

.
That would be a new question. You will need to post a separate question to the forum.

 

[HayabusaPR]

Thanks