Open Workbook Using VBA
Dear All,
I want to open an additional workbook using VBA.
'Where I get file name; This works
txtTradeTrackerFile = ThisWorkbook.Worksheets("Access").Cells(3, 5)
'I don't know how to solve this cause of error in my project
'It works in Access. However, in Excel I really don't know :-)
Set xBook = Workbooks.Open(CurrentProject.Path + "\" +
txtTradeTrackerFile)
Please give me suggestion.
Thanks,
March
|