Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting path for getopenfilename???

Status
Not open for further replies.
Jooky68

Jooky68

Programmer
Jul 10, 2002
231
US
Is there any possible way to set the path for a getopenfilename statment. I dont want it to comeup in the current directory?? any ideas or possible code arounds?
 
Sort by date Sort by votes
chdir "c:\my_folder\my_subfolder"
 
Upvote 0 Downvote
wow...why didnt i think of that?!?! thanks a lot
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
949
strongm
strongm
sxschech
  • Locked
  • Question
For Each Loop works once then gives error 91 2
Replies
19
Views
822
sxschech
sxschech
renigar
  • Locked
  • Question
Fishing for Ideas on sorting sheets in workbook
Replies
5
Views
382
SkipVought
S
JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
368
dhookom
dhookom
remeng
  • Locked
  • Question
Row count for table after filtering
Replies
8
Views
1K
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top