G
Guest
Using XL 2003 & 97
Would like to use a variable (WBPath) for the file path, and add to it, a
filename and use all of it to open a workbook. I am simplifying the data
below - meaning that I need to use a variable for the path.
.........
.........
Dim WBPath As String
WBPath = Workbooks("myFile.xls").Path
.........
.........
(Cannot get the correct syntax for the following
Set OldWkbk = Workbooks.Open(Filename:=WBPath & "myFile.xls")
.........
.........
TIA for your time and knowledge,
Dennis
Would like to use a variable (WBPath) for the file path, and add to it, a
filename and use all of it to open a workbook. I am simplifying the data
below - meaning that I need to use a variable for the path.
.........
.........
Dim WBPath As String
WBPath = Workbooks("myFile.xls").Path
.........
.........
(Cannot get the correct syntax for the following
Set OldWkbk = Workbooks.Open(Filename:=WBPath & "myFile.xls")
.........
.........
TIA for your time and knowledge,
Dennis