Proper syntax for GetOpenFileName

[ShaneDevenshire]

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.

 

[JE McGimpsey]

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.

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

myName = Application.GetOpenFilename("XLS8")

 

[ShaneDevenshire]

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!