Edit excel file with external vbscript

[SlakeB]

I want to make some formatting changes to an excel file by using an external .vbs file. Specifically I need to:

1. select all cells and remove word wrapping
2. change the text in one of the cells
3. reformat the dates in one of the columns

Can anyone lead me in the right direction?

 

[PHV]

As a starting point, use the Excel macrorecorder to get some VBA code you can easyly convert to VBS.

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