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!

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!