Export to excel

[jenbug2000]

I need some help finding some good code examples. I have a program that exports to excel from a database (clientside vbscript) but it takes away the leading zeros in my column. I would like to add a ' mark to the front of each number in my first column before it loads into the excel column, so that it does not truncate the zeros.

I would appreicate being pointed in the right direction on how to resolve this issue. I have done a millon searches and cannot seem to find any examples of code that might do this.
Thanks in advance
jen.

 

[PHV]

Why not simply use a personalized format in Excel ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jenbug2000]

Hi,

Not exactly sure what you mean. But It has to be formatted before it gets to the excel worksheet because it will be on a clients machine and I will have no control over it at that point.

Thanks

Jen

 

[SaMaLaKo]

Can you show us (a piece) of the code how you extract it from the database to excel?
To see what we are up against...
thnx..

--------------------------------------
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs,
and the Universe trying to produce bigger and better idiots.
So far, the Universe is winning.