Dear all,

I'm currently writing an Excel macro and in that macro i need to change
the Default File Path (where i open\save my files concerning this
macro)

I know that setting Application.DefaultFilePath is what i need to do,
but
if i write a simple macro like this:


Code:
--------------------

Sub test()
With Application
.UserName = "Paulo Fonseca"
.StandardFont = "Arial"
.StandardFontSize = "10"
.DefaultFilePath = "c:\test"
.EnableSound = False
.RollZoom = False
End With
End Sub

--------------------


and then run it nothing changes, except the field in
TOOLS-OPTIONS-GENERAL- Default File Locations witch is now c:\test .
But still when i click on Open File it goes to the previous location.

If i do this procedure by hand (going through the menus and change the
Default file location), and then click on Open File it works!!

Do i miss any command ond my macro?
Thanks in advance

Best regards
Paulo Fonseca


--
paulojfonseca
------------------------------------------------------------------------
paulojfonseca's Profile: http://www.excelforum.com/member.php...o&userid=24976
View this thread: http://www.excelforum.com/showthread...hreadid=385071