Link to home
Start Free TrialLog in
Avatar of mmitchell57
mmitchell57

asked on

VBScript, XLS, Formattting and other Functions

Hello, does anyone have a list of properties that you can change when writing a XLS file from VBScripting?  Thing I am interested...

How to write to multiple sheets in the same file... Say a new page per server, but in the same xls.
How to change the cell colors
How to change font, font size, font color

If there is a reference with the entire list properties, it'd be great.
ASKER CERTIFIED SOLUTION
Avatar of exx1976
exx1976
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mmitchell57
mmitchell57

ASKER

Thank you for the hint about Macro's. That will help out quite a bit. Also, thank you for all the snippets. :)