Hi All,

I'm trying to set the FileFilter for a GetSaveAsFileName function in
macro to CSV. I can do it for the PC Version, but for the Mac I nee
the File type code for these formats (CSV Mac, CSV Windows and CS
MS/DOS | OS/2).

I have looked everywhere but because Apple doesn't release them, I can
find them at all.

Can anyone help me?

Thanks you heaps in advance.

Lia

--
Message posted from http://www.ExcelForum.com

The File Type code for all of the text file types you specified is
"TEXT".

Note that while Apple may keep a list of File Type Codes somewhere, they
don't assign them - that's up to the application developer.

In article ,
Sportiva wrote:

I'm trying to set the FileFilter for a GetSaveAsFileName function in a
macro to CSV. I can do it for the PC Version, but for the Mac I need
the File type code for these formats (CSV Mac, CSV Windows and CSV
MS/DOS | OS/2).

I have looked everywhere but because Apple doesn't release them, I cant
find them at all.

Thanks for your reply.

I've did try TEXT but then the GetSaveAsFileName window opens wit
filename.txt, instead of filename.csv as a default.

I'm trying to make the process as simple as possible for a userbas
that has a lot of less computer-savvy people. Is there anyway that yo
know to do that?

On the PC, I set the file filter as "CSV Files, *.csv" and this doe
that.

I also need this to restrict the GetOpenFilename to CSV files as well
so that is all they can open.

Thanks again for your help,

Lia

--
Message posted from http://www.ExcelForum.com

I have the identical issue as you described. I'm trying to come up with
PC/MAC comnpatible way for a user to save a CSV file, using
GetSaveAsFileName. All's well on the PC side, but not so on the Mac.
Even when I specify FileFilter:="Text", the default filename displayed
ends in .xls.

Has anyone come up with a way to use .GetSaveAsFileName and display the
filename with the desired file type (in my case, .csv)?

Paul


--
Paul Laba
------------------------------------------------------------------------
Paul Laba's Profile: http://www.excelforum.com/member.php...o&userid=23739
View this thread: http://www.excelforum.com/showthread...hreadid=225968