| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Reference
In this code, there is a file reference to the "September 04.xls"
spreadsheet. How can I change it so that it will always reference this workbook instead of looking for the file? Application.Run "'September 04.xls'!SortATT" Sheets("ATT").Select I'm using Excel 97 if that makes any difference! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File Reference
If you mean the the sub SortATT is in the current workbook, then just change
the code to SortATT Sheets("ATT").Select On Mon, 4 Oct 2004 13:41:05 -0700, simsjr wrote: In this code, there is a file reference to the "September 04.xls" spreadsheet. How can I change it so that it will always reference this workbook instead of looking for the file? Application.Run "'September 04.xls'!SortATT" Sheets("ATT").Select I'm using Excel 97 if that makes any difference! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking to another file using file reference typed cell | Excel Worksheet Functions | |||
| cross-reference data from one file to another file | Excel Discussion (Misc queries) | |||
| File reference | Excel Worksheet Functions | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
| copy/paste from one file to another without file name reference | Excel Discussion (Misc queries) | |||
Linear Mode
