csv file with special separator
 

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

csv file with special separator
 

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.

--
Regards,
Tom Ogilvy

"morsi" wrote in message
oups.com...
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

csv file with special separator
 

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 :

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.

--
Regards,
Tom Ogilvy

"morsi" wrote in message
oups.com...
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

csv file with special separator
 

Nothing that I am aware of.

--
Regards,
Tom Ogilvy

"morsi" wrote in message
oups.com...
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 :

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.

--
Regards,
Tom Ogilvy

"morsi" wrote in message
oups.com...
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

csv file with special separator
 

morsi wrote:
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 he

http://www.microsoft.com/downloads/d...0-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

--
HTH,

okaizawa

csv file with special separator
 

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.

csv file with special separator
 

morsi wrote:
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...b;en-us;291296

--
HTH,

okaizawa