AW: Sending Reports To CSV
Ok, so this is not a JDE issue per se. However, it originates in a UBE
calling "automatically" Excel. Did anybody find a way how to setup Excel to
format cells into the "Text" format by default? Apparently, when called
"automatically", Excel formats cells into the "General" format, even if a
template with all cells formatted to "Text" for sheet.xlt or book.xlt has
been setup. The template apparently works only when creating / opening a new
worksheet, but not for these "automatic" calls. Is there something which
could be setup in the registry? For .csv, there is a Excel-related entry?
Any Excel or Windows experts out there?
Just asking. I agree that the data import wizard works very well.
Thank you, Nico
Nico Wohldorf
WOHLDORF SYSTEMS, INC.
25 San Miguel Avenue, Suite 2204
MPO Building, Ortigas Center
1600 Pasig City, Philippines
Direct/Voice: +63.2.633.1855, ext. 215
Facsimile: +63.2.638.5646
Cellular: +63.918.903.6411
E-Mail: mailto:
[email protected]
URL:
http://www.wohldorf.com
"Excellence in Integrated Management Systems"
-----Ursprüngliche Nachricht-----
Von:
[email protected] [mailto
[email protected]]Im
Auftrag von cuhand
Gesendet: Monday, April 29, 2002 1:59 PM
An:
[email protected]
Betreff: Re: Sending Reports To CSV
1. Send the output to text file
2.Start Excel
3. Open the text file . Text import wizard will start.
4. In step 3 of 3 of TIW, select the P/N column and select column data
format as text
Enjoy
--------------------------
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=33588
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com
JDEList is not affiliated with JDEdwards®
+ - - - - - - - - - - - - - - - - - - - - - - - -+