Pick a File with FileDialog

Hi Alex. I use the pick a file with FileDialog. My photos are not stored on my C drive. So when I go to pick a file, windows explorer takes me to the documents folder on my C drive. What I am asking, is there a way so that I can set up a default, so that when I click on the browse button to run the above programme, it can take me to the right folder on my E drive where the photos are stored. Thank you.

Use:

To pick a file, starting in the folder C:\MyFiles:

    MyTextFieldHoldingTheFileName = PickFile("C:\MyFiles\")

Thank you Scott. I have tried putting this line in different places but it keeps bringing up an error. So does it go it go in the initial Filedialogue section? It kept telling me there were errors. Any assistance would be great. Thank you

Are you not using the PickFile() function Alex pointed you to?  if not, what code are you using to ask for the file name?

Colin,

You need to put the code in the Click Event of a Button.
You are a beginner so I would watch Intro To VBA if you haven't already.

Hi Scott. Yes I am using the Pickfile() function and it works fine. Yes Kevin you are correct about being a bit of a beginner especially with VBA. However, I do have the code in the click event of the button. What I am not sure is where I put the statement that Scott sent in relation to the rest of code eg is it placed immediately before Photo6 = Pickfile() or somewhere else? I have previously watched the intro to VBA but when you are not using it all the time, things slip out of the memory. Thank you all for your advice and help

Did you use the code in the Images Extended Cut?
If so, enter the following line BEFORE FO.Show replacing what is in the quotes with the full path of your default folder.

FO.InitialFilename = "C:\YourPath\"

Hi Kevin. Yes I did use the code as you mentioned. I have now added the line where you suggested and it works perfectly. Thank you Kevin for helping to deal with my lack of expertise - I really appreciate everyone's advice and help. Many thanks