Mike - I've done the Automation approach - as I already mentioned below. But - there are drawbacks as I mentioned - for one being that when my QA Tech goes and attempts to install it on the clients system - they install & test it on their server - which does NOT have Excel. So - that means it wont work. Plus - there is the overhead of Automation being slow...
But, yes, I have done Automation before - to solve some very specific problems! -K- -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Monday, August 22, 2011 1:57 PM To: profoxt...@leafe.com Subject: Re: FoxPro to Excel & Exponential Looking Data On 8/22/2011 1:50 PM, Kurt Wendt wrote: > I looked thru all the old e-mails I got from ProFox and could not seem > to find this. Even though I am SURE someone in the group mentioned this > problem - and somewhat recently. Oh well, here goes... > > > > I have this one utility that needs to export data to Excel. Which, for > the most part - it does it just fine. The problem is, I need to be able > to export this like a FedEx or UPS Tracking # that the user must enter. > And, if that tracking number is big and all digits (like 18 digits long) > - when you open the Excel file - those tracking numbers get displayed as > some kind of Exponential number. > > > > I'm sure others have run into the problem. So - what is the best > solution for this issue? I know I can do some Office Automation to fix > it - but, I would rather avoid Automation - for many of the obvious > reasons and drawbacks for going that route. > Not sure if you feel comfortable with the automation approach, but if you do, then create a template ahead of time (assuming fixed/constant data) and then insert into that using Office Automation. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140b7cd...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
