VBScript + Excel

  JurgenG 22:07 25 Jan 05
Locked

Hi,

can anyone tell me how I can use the data from a field in Excel in a variable in a VBScript (WSH)?

Thanks

  VoG II 22:09 25 Jan 05

I think that we need a LOT more information, please.

  JurgenG 22:22 25 Jan 05

OK, in the software we use in my company I have a lot of data I would like to modify.

As the software in itself does not allow it, I would like to do it myself.

The easiest way for me is to export the data from the software to excel (the soft does allow that) and then, after having modified it in the excel file, to reimport it (which the soft does not allow).

I can do that in a VBscript with cut and paste using the Sendkeys Method but sometimes I would like the VBscript to make a decision according to the data it finds in the Excel field.

So I'm looking for a way to do this. If I could get the data of that Excel field into a variable in the VBscript I'd be able to solve this.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…