create excell and modify properties

[ShadowFox333]

I need to read a .csv file into excel and then change the properties of a numeric field to zip and save as a native mode.xls any ideas out there.
Thanks Bob

 

[PHV]

What have you so far ?
Try a keyword search in this forum for excel.application

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

 

[dilettante]

There are a couple of methods given in thread329-782027

What did you mean by "zip?" Were you just saying you wanted to make a zip archive of the resulting xls file?

 

[ShadowFox333]

Dil
One of the fields(cells) is a numeric field. Actually a zip code. Leading zeroes are stripped unless you set the field property to zip. Then the cell retains the leading zero.
Bob

 

[dilettante]

Oh! Sorry.

Well can't you just set objWS.Columns("A:A").NumberFormat = "00000" to get the desired result?

I'm no Excel expert, but... When I manually set the named format to "Zip" vis the Format Cells dialog and then fetch the cell's Numberformat property in a macro I get back "00000" and not the word "Zip.