View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Batch Excel worksheet formatting

For xl97 and earlier or non XML format excel files
Unless you are willing to understand the excel file format, compound
documents and decipher how this information is stored within, you will need
to use Excel as the engine to do these changes

For excel files stored as XML, then perhaps you can more easily discover the
appropriate data fields to change.


--
Regards,
Tom Ogilvy



"keithdm706 " wrote in message
...
I am looking for a way to formatt excel worksheet cells from a batch
program and save the changes to that worksheet without opening the
worksheet.

I need to change the size of the cells in the worksheet, and also
change the formatt type of a numeric cell.


---
Message posted from http://www.ExcelForum.com/