View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
March March is offline
external usenet poster
 
Posts: 34
Default 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