VB Script help for Changing cells in Excel

unique12u · Post by **unique12u** » Mon Apr 10, 2006 3:18 am

I need to change certain rows in a column in excel based on the value in another column. Can someone give me some VB script help on doing that.

IE IF A1=1 then B1=2

Thanks
Nique

Post by **Marcus Tettmar** » Tue Apr 11, 2006 9:18 am

The easiest way to do this is actually to use DDE with DDERequest and DDEPoke rather than with VBScrip. There are examples on these forums showing both DDE and VBScript methods for manipulating Excel data. If you search you will find them. Click on search link above and try following queries:

DDERequest Excel

excel.application vbstart