VBA code to grab a file path from an Excel cell

[fwk]

I have a workbook that downloads data from SAP. This workbook is developed to be a tool for different users across different sites. What i am trying to achieve is to develop VBA code that refence a spesific cell on a sheet where the different users can copy in the file path of where they store the data.

The current working code has this:-

' Open the IW39 Dwnld workbook
Workbooks.Open ("C:\Users\10005500\OneDrive\Desktop\SAP Automated data extract\Material Report\SAP Downloads\IW39 Dwnld.xlsx")
Sheets("Sheet1").Select
Range("A1").Select

I need the VBA to reference the cell in the sheet below (A2) where this path is stored. Below is a snippet of the sheet where users input their criteria. Each site would hence have different criteria and it would be better managed to input on the sheet instead of manipulating the VBA code for each.

I am a beginner in VBA and any assistance and detailed explanation how this can be achieved would be appreciated.
FWK

 

[gplhl]

Concatenate the cells and declare that as a variable, then use that in your open statement.

 

[gplhl]

Concatenate the cells and declare that as a variable, then use that in your open statement.

Where my cells were A1 for Path and A2 for Filename

Sub myOpenWorkbook()

WorkbookToOpen = Range("A1").Value & "\" & Range("A2").Value & ".xlsx"

Workbooks.Open (WorkbookToOpen)

End Sub

 

[fwk]

Concatenate the cells and declare that as a variable, then use that in your open statement.

Where my cells were A1 for Path and A2 for Filename

Sub myOpenWorkbook()

WorkbookToOpen = Range("A1").Value & "\" & Range("A2").Value & ".xlsx"

Workbooks.Open (WorkbookToOpen)

End Sub

Thankyou very much, I will test it.