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!
|