![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Feb 2002
Posts: 76
|
When I do a GetOpenFilename(), it works ok, but I want to be able to choose the path
that first pops up when this method is used. (Its the last path changed to by the user) How can I access the path that automatically is searched when a Getopenfilename is used? Thanks. |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Mar 2002
Location: Wellington
Posts: 104
|
Before the getopenfilename(), insert the following 2 lines:
ChDrive ("C:") ChDir ("C:temp") Application.GetOpenFilename |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Mar 2002
Location: Wellington
Posts: 104
|
correction, only 1 '' instead of 2
|
|
|
|
|
|
#4 |
|
Board Regular
Join Date: Feb 2002
Posts: 76
|
I dont understand the correction, do you mean 1 of the back slashes each time, or 2 backslashes 1 time? Oh, I guess I'll figure it out! |
|
|
|
|
|
#5 |
|
Board Regular
Join Date: Mar 2002
Location: Wellington
Posts: 104
|
yes, only 1 slash instead of 2. for some reason, this forum converted my 1 slash into 2.
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|