Proper syntax for GetOpenFileName

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ShaneDevenshire - 18 Jul 2007 05:50 GMT

Hi Folks,

for opening text files the proper syntax for this command is
myName = Application.GetOpenFileName("TEXT")

If I want to do the same thing for Excel files the Help system seems to say
you should use:
myName = Application.GetOpenFileName("XLS4")

However, this causes an error. Can someone provide me with the correct
syntax.

Signature

Thanks,
Shane Devenshire

Reply to this Message

JE McGimpsey - 18 Jul 2007 06:46 GMT

> Hi Folks,
>
[quoted text clipped - 7 lines]
> However, this causes an error. Can someone provide me with the correct
> syntax.

Standard XL97/98->XL2003/2004 file type is XLS8.

myName = Application.GetOpenFilename("XLS8")

Reply to this Message

ShaneDevenshire - 18 Jul 2007 16:42 GMT

Hi,

Well, you know I tried everything from XLS4 to XLS11 and none worked, but
after your post I thought - maybe this is because the files are PC versions.
So I opened one of the files and saved it right back. And everything worked
just fine!

Signature

Thanks,
Shane Devenshire

> > Hi Folks,
> >
[quoted text clipped - 11 lines]
>
> myName = Application.GetOpenFilename("XLS8")

Reply to this Message

Mac Forum / Applications / Excel / July 2007

Proper syntax for GetOpenFileName