File Reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
If you mean the the sub SortATT is in the current workbook, then just change
the code to

SortATT
Sheets("ATT").Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run code from another workbook 7
MACRO to save current worksheet with variable filename 1
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
Changing embedded file name 2
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed 15
New try, Help needed 2
Reference workbook name to cell reference 2
Help with activating window from Application.GetOpenFilename 4

Back
Top