ExcelBanter - Default Path for File Open

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

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

- - Default Path for File Open (https://www.excelbanter.com/excel-programming/324644-default-path-file-open.html)

gilgil

Default Path for File Open

I want the DialogBox open on the folder E:\Transit

Application.DefaultFilePath = "E:\Transit"
FileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")

Why this code don't works?
Thank!

--
gilgil

Bob Phillips[_6_]

Default Path for File Open

ChDrive "E:\Transit"
ChDir "E:\Transit"
FileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")

--

HTH

RP
(remove nothere from the email address if mailing direct)

"gilgil" wrote in message
...
I want the DialogBox open on the folder E:\Transit

Application.DefaultFilePath = "E:\Transit"
FileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")

Why this code don't works?
Thank!

--
gilgil

gilgil

Default Path for File Open

Thanks, it work OK
--
gilgil

"Bob Phillips" ha scritto nel messaggio
...
ChDrive "E:\Transit"
ChDir "E:\Transit"
FileName = Application.GetOpenFilename("Text Files (*.txt), *.txt")

All times are GMT +1. The time now is 08:45 AM.