VBScript + Excel

  JurgenG 22:07 25 Jan 05


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


  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.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch