ExcelBanter - Open Folder

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Open Folder (https://www.excelbanter.com/excel-programming/275221-re-open-folder.html)

PEdro

Open Folder

"Pedro" wrote in message news:...
What code should I write to open in a box like the File\Open a specific
folder?

Thanks
PEdro

Tom Ogilvy

Open Folder

Chdrive "C"
ChDir "C:\MyFolder\MyFolder2"
fName = Application.GetOpenFileName( arguments)

See help on GetOpenFileName for list of arguments and formats.

--
Regards,
Tom Ogilvy

"Pedro" wrote in message
...

"Pedro" wrote in message news:...
What code should I write to open in a box like the File\Open a specific
folder?

Thanks
PEdro

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