Thread: File Reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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!