darin.kelberlau@[EMAIL PROTECTED]
writes:
>
> When I run the following code I get an error:
>
>
> CODE:
> fname=Application.GetOpenFilename(filefilter:="TEXT FILES(*.TXT),
> *.TXT")
>
>
> ERROR:
> Run-time error '1004'
> Method 'GetOpenFilename' of object '_Application' failed
>
>
> This works on a PC but not on a Mac!!
That is because the format of the file filter string differs between
Macs and PCs. On the Macintosh, the string is a list of comma-separated
file type codes. You will want to use "TEXT" as the rough equivalent of
the above file filter item.
Of course, with OS X, the file types are not always present, so that
could pose some problems. However, you could probably use the "TEXT"
filter type.
>
>
> PLEASE HELP!!!!
A good resource is the VBA help for Excel in the VBA Editor.
--
Thomas A. Russ, USC/Information Sciences Institute
|
