Need Mac File Type Code for CSV formats
 

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

Need Mac File Type Code for CSV formats
 

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.

Need Mac File Type Code for CSV formats
 

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

Need Mac File Type Code for CSV formats
 

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