ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Browse dialoge (https://www.excelbanter.com/excel-programming/340597-browse-dialoge.html)

Tempy

Browse dialoge
 
Hello all, is it possible to point to a certain folder when the
"Application.FindFile" is used ?
Is this the best method to use ?
In other words when the dialog box opens it is already in that folder so
the user has just to select the required file ?

If so could you please help me some code.

Thanks in advance.


Tempy

*** Sent via Developersdex http://www.developersdex.com ***

Tom Ogilvy

Browse dialoge
 
Chdrive "D"
ChDir "D:\MyFolder1\MySubfolder1"

now show the dialog.

--
Regards,
Tom Ogilvy


"Tempy" wrote in message
...
Hello all, is it possible to point to a certain folder when the
"Application.FindFile" is used ?
Is this the best method to use ?
In other words when the dialog box opens it is already in that folder so
the user has just to select the required file ?

If so could you please help me some code.

Thanks in advance.


Tempy

*** Sent via Developersdex http://www.developersdex.com ***




Tempy

Browse dialoge
 
Thanks very much Tom.

best regards,

Les Stout



*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com