Open an Excel workbook
|
Macro Title:
|
|
Worksheet Path and Name Variable::
|
|
Worksheet Name:
|
|
Cell Reference:
|
|
First Comment:
' |
|
Second Comment:
' |
Sub Open_a_Workbook_through_Cell_Reference()
'declare a variable
Dim wbfilepath As Variant
Set wbfilepath = Worksheets("Parameters").Range("A1")
'open a workbook that is referenced to in cell A1 in the Parameters sheet
wbfilepath
End Sub