GetOpenFileName??

Posted by steve on January 03, 2002 7:35 AM

hello,

is there a way to control the path getopenfilename uses as its default? lets say the getopenfilename function opens to "c:\my documents\excel\" but i'd like it to default to "c:\iamadork\myheadhurts\". is this possible?

also i tried to distribute a macro i wrote for these guys the other day and the macro showed up but not my pretty little smiley faced button. any idea why this is happening?

thanks a ton. as soon as i get these last two things done i can go home, where my pillow and blankies are =)

steve

Posted by Scott on January 03, 2002 8:05 AM

You can control what directory opens by going to Tools-Options then select the General Tab, and put the path that you want under "default file location" You can do this with a macro also. Something like:

Sub Chg_directory()

With Application
.DefaultFilePath = "C:\Documents and Settings\user\JohnDoe

End With
End Sub

Posted by steve on January 03, 2002 8:19 AM

great, thanks a ton