Format Excel Columns

  • Thread starter Thread starter Frank H
  • Start date Start date
F

Frank H

Can anybody assist?

I'm using code to write / format an excel worksheet,
mostly its going fine. What I cant work out is how to :

a) Set the text alignment for a whole column
b) Set the format (0.00) for a whole column

Have tried to work out, copy settings using Excel macros,
but no results yet

TIA

Frank
 
Hi Tom

I'm using 2002
Still a bit of a newbie at this, needed to get some data
from a SQL db and a Foxpro system, link them via Access
table & produce a formatted Excel worksheet from the
result.

Spent all day working it out, (mainly by recording macros
whilst changing settings on a template workbook) and
seeing which settings / properties were affected.

Using Doug's advice, managed to get going pretty well.

I'm afraid I don't know anything yet about webservices. I
suppose that's something else I'll have to learn - getting
too old for this !

I can send you the code I created if you like, it's still
primitive, but it works, let me know if you want it.

Rgds

Frank H
 
Back
Top