Hello,
Database produces output files as text delimited files with CSV extension.
Problem is that different versions of ms excel has different default
delimiter: comma or semicolon.
How to configure ms-excel: default field separator (delimiter), to be the
same on all workstations
opening these files ? Open must be full automatic - just by clicking CSV
file in the explorer, users
are not a gurus..
Thanks and regards,
GG
..csv files should open automatically (no import dialog) in Excel when
they are clicked in Explorer. Your system may not be set to use Excel
for these files.
Try copying & pasting this to an empty text file named excelcsv.reg;
first verify (and correct, if necessary) the pathname to Excel.exe.
Be sure to use the double backslashes and leave the backslashes in
front of the quote marks. (It's a C/C++ thing) then double-click the
file to merge it into your registry:
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.csv]
@="Excel.CSV"
[HKEY_CLASSES_ROOT\.csv\Excel.CSV]
[HKEY_CLASSES_ROOT\.csv\Excel.CSV\ShellNew]
[HKEY_CLASSES_ROOT\Excel.CSV]
@="Microsoft Excel Comma Separated Values File"
[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]
@="{00020820-0000-0000-C000-000000000046}"
[HKEY_CLASSES_ROOT\Excel.CSV\shell]
@="Open"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open]
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office\\EXCEL.EXE\" /e"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open\ddeexec]
@="[open(\"%1\")]"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open\ddeexec\application]
@="Excel"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open\ddeexec\topic]
@="system"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print]
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\command]
@="\"C:\\Program Files\\Microsoft Office\\Office\\EXCEL.EXE\" /e"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\ddeexec]
@="[open(\"%1\")][print()][close()]"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\ddeexec\application]
@="Excel"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\ddeexec\ifexec]
@="[open(\"%1\")][print()][quit()]"
[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\ddeexec\topic]
@="system"
Mike Argy
Custom Office Solutions
and Windows/UNIX applications
Please post on-topic responses to the newsgroup
To e-mail me, remove nospam from the address in the headers