Excel needs BROWSE in tools-options-general-default file location
 

Changing data file location in Word is easy, just browse in a GUI environment.

Changing data file locations in Word is like being in the "dark" ages.
We must KEY the full path name. (or may be able to paste).

Excel needs a GUI BROWSE option to enter default file location. . .

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup

Excel needs BROWSE in tools-options-general-default file location
 

How about copying the new sheet to one with the permanent sheetname.

You can probably record a macro using edit, move or copy sheet, copy sheet.

Sub Macro14()
On Error Resume Next
Sheets("permanent sheet").Delete
On Error GoTo 0
' ---Sheets("Summary").Copy befo=Sheets(1)
ActiveSheet.Copy befo=Sheets(1)
ActiveSheet.Name = "Permanent sheet"
ActiveWorkbook.Save
End Sub







--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Homer" wrote in message ...
Changing data file location in Word is easy, just browse in a GUI environment.

Changing data file locations in Word is like being in the "dark" ages.
We must KEY the full path name. (or may be able to paste).

Excel needs a GUI BROWSE option to enter default file location. . .

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...ic.excel.setup

Excel needs BROWSE in tools-options-general-default file location
 

sorry replied to the wrong question.

But I do kind of wonder why the poster needs a GUI file
interface for a permanent setting -- tools, options, General,
Default file location. Seems to me something that would
only be useful under File, Save As and you will find it there.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Homer" wrote in message ...
Changing data file location in Word is easy, just browse in a GUI environment.

Changing data file locations in Word is like being in the "dark" ages.
We must KEY the full path name. (or may be able to paste).

Excel needs a GUI BROWSE option to enter default file location. . .

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.



http://www.microsoft.com/office/comm...ic.excel.setup