Pick file from "Open File" always from same folder 1

[xsubzeroz]

Can someone please help me. Thanks in advance. In Excel I'm using click button to have "Open File" window come up. I would like to do, when I click button I want "Open File" window come up always defaulting to same folder and I then I will select file I need. Right now I have very, very simple code:

Sub Macro2()
Excel.Application.GetOpenFilename
End Sub

Can someone tell me what to add to default to same folder all the time. Lets say "C:\My Documents\Parts". I would really appreciate your help.

 

[SkipVought]

xsubzeroz,

Tools/Options - General tab - default file location



Skip,

http://www.TheOfficeExperts.com

 

[xsubzeroz]

Thank you SkipVought, that's a very handy option to know. The only thing that I want to know if I do the way you said, and save this file on network with these command buttons, if other people open this file, will they will be redirect to same folder?? Or is it just my computer will be set to that?? Thanks.

 

[SkipVought]

Get the user default, set yours, get the filename, set it back to user default

With Application 
  UserDefault = .DefaultFilePath 
  .DefaultFilePath = "C:\My Documents\vbaProjects"
  fName = .GetOpenFilename
  .DefaultFilePath = UserDefault 
End with

Skip,

http://www.TheOfficeExperts.com

 

[Loomah]

Hi
You could also use
ChDir ""C:\My Documents\Parts"
before getopenfilename

This changes the default for the current xl session. Combine it with Skip's code to remember the default and reset it and you're away!
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244