| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing Workbook Name
I have the following VBA code in which I am identifying the number of rows in
a workbook named "FileOpenNameLast." This name includes the full path of the workbook and, therefore, my code deosn't work. Isn't there a simple way to refer to the workbook name in my code? NumRowsF832 = Workbooks(FileOpenNameLast).Name.Sheets(1).Range(" A65536").End(xlUp).Row -- Ken Hudson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing other workbook. | Excel Worksheet Functions | |||
| Referencing a different Workbook | Excel Worksheet Functions | |||
| Referencing another Workbook | Excel Discussion (Misc queries) | |||
| referencing another workbook | Excel Programming | |||
| Referencing one workbook in other??? | Excel Programming | |||
Threaded Mode
