AS400 file with formulas into Excel

Subject: AS400 file with formulas into Excel
From: Jeff Wilson <jeffwilson@xxxxxxxxx>
Date: Wed, 8 Jul 2009 11:10:14 -0700 (PDT)
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@xxxxxxxxxxxx?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@xxxxxxxxxxxx>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@xxxxxxxxxxxx?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@xxxxxxxxxxxx?subject=unsubscribe>

I can create a file in SQL that has formulas in it (i.e. '=A1*B1') and I can send them to my PC and open them in Excel 2002. However, the formulas are showing instead of the results. If I click inside the cell and hit Enter, I get the value instead of the formula. BUT, I want this automated and don't want a macro, so I want this to be opened to show the formula result instead of the formula without doing anything. I tried using CAST to a few other types, but that didn't work. It works if I send it as a HTML, but would prefer the xls extension, if possible. Thanks for any thoughts on this.

-Jeff

This thread ...

AS400 file with formulas into Excel, Jeff Wilson <=
- Re: AS400 file with formulas into Excel , Pete Helgren

Follow-Ups:
- Re: AS400 file with formulas into Excel , Pete Helgren

Prev by Author: Re: FTP Priority?
Next by Author: Re: AS400 file with formulas into Excel
Previous by thread: RE: RMVLNK issue
Next by thread: Re: AS400 file with formulas into Excel
Index(es):

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2010 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact