Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) |