Opening files

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

Guest

I have tried to use the GetOpenFilename application in VBA so that I would be
able to get the Open dialog box to display at a specified place but it will
only display the open dialog box of the last file opened is there a
application or another method of getting the Open file dialog box to display
at a specific place or not? Thank you

Heath
 
Use the ChDir statement (and perhaps ChDrive as well if you need a different
drive) to switch to the directory you want before you execute the
GetOpenFileName line.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Workbook Question 1
GetOpenFilename with default filename? 5
Can I do this autoselect with GetOpenFileName or the Dir function? 1
Sheet select 3
Using GetOpenFilename from a cell 6
GetOpenFilename 1
Want to create a file open box using a dialog box 1
Dialog box for user to select a folder 6

Back
Top