csv file with special separator

[morsi]

I have file with special extension and i would like to associate this
file to excel as a csv file. My file has the caracter "|" as separator.
How to force excel to use this separator when opening the file by a
double-click on the file ?
Thanks

 

[Tom Ogilvy]

I doubt there is any way to redefine the separator for just one file
extension. You associate files in the folder options area of windows.

 

[morsi]

Can i use something special in "use dde" fields of the explorer "Edit
file type" ? or modifying some windows registry keys ?

Tom Ogilvy a écrit :

 

[Tom Ogilvy]

Nothing that I am aware of.

--
Regards,
Tom Ogilvy

Can i use something special in "use dde" fields of the explorer "Edit
file type" ? or modifying some windows registry keys ?

Tom Ogilvy a écrit :

 

[okaizawa]

Can i use something special in "use dde" fields of the explorer "Edit
file type" ? or modifying some windows registry keys ?

[open( )] in 'DDE Message' is a excel4 macro function.
the reference is here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c09bf7f7-d30e-4ce9-8930-5d03748ca5cd
http://support.microsoft.com/kb/143466/EN-US/

define 'open' action for your file type, for example:
(only 'DDE Message' is customized. others are the same for .xls)

Application used perform action:
".....\EXCEL.EXE" /e %1

[v]Use DDE (check)

DDE Message:
[open("%1",,, 6,,,,, "|")]
or
[open.text("%1",,,,,,0,0,0,0,1,"|")]

Application:
Excel

DDE Application Not Running:


Topic:
system

 

[morsi]

Thank you very much okaisawa,
It's OKAY
Do you know any tutorial which explain the DDE message
([open.text("%1",,,,,,0,0,0,0,1,"|")] ) syntax ?

Now, I would like to automatically save the file with the specific
delimitor et extension.
Morsi.

 

[okaizawa]

Do you know any tutorial which explain the DDE message
([open.text("%1",,,,,,0,0,0,0,1,"|")] ) syntax ?

Now, I would like to automatically save the file with the specific
delimitor et extension.

i have not seen any other document. i referred to the help file and
followed other predefined actions.

perhaps excel cannot output a text file with a specific delimiter that
is not built-in, by itself.
this is an example of a macro:

Procedure to export a text file with both comma and quote delimiters in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;291296