| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a File
I need a way to activate a workbook. I am in the open
workbook that has a 8 character file name 1234.xls. The workbook I would like to activate is the same name, less 2 characters in the name or 12.xls. I have been trying the following but neither work TmpName2 = Left(ActiveWorkbook.Name, Len (ActiveWorkbook.Name) - 6) Workbooks.Open ("C:\ path\" & tmpName2 & ".xls") Or Windows("tmpName.xls").Activate Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening a file in Excel starts application but dose not open file | Excel Discussion (Misc queries) | |||
| Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
| File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
| "Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Linear Mode
