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

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

Guest

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/com...-2ba72312ea65&dg=microsoft.public.excel.setup
 
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 before:=Sheets(1)
ActiveSheet.Copy before:=Sheets(1)
ActiveSheet.Name = "Permanent sheet"
ActiveWorkbook.Save
End Sub







--


Homer said:
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.
Click to expand...
http://www.microsoft.com/office/com...-2ba72312ea65&dg=microsoft.public.excel.setup
 
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.
--
 
Back
Top