Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Batch Excel worksheet formatting

I am looking for a way to formatt excel worksheet cells from a batc
program and save the changes to that worksheet without opening th
worksheet.

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

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the links in Excel at one batch? LunaMoon Excel Discussion (Misc queries) 1 April 24th 10 12:59 AM
Can excel run a batch file? Tom Excel Discussion (Misc queries) 2 June 1st 09 02:46 AM
run batch job from each row - how to insert run batch function per row? Mitchell_Collen via OfficeKB.com Excel Discussion (Misc queries) 5 February 26th 09 07:16 AM
Batch print excel files Lamb Chop Excel Discussion (Misc queries) 1 November 7th 07 02:47 PM
Excel to Run a Batch File?!? carla New Users to Excel 3 January 20th 07 02:32 AM


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"