How to run the excel macro tool using VB script

[laks143]

Hi all,

I want to run a excel macro tool which is already opened
by giving proper inputs like date(20/12/2008) in B4 cell and 10 digit policy number in A4 cell ..

even i want to know how to press the buttons on the tool by VB script.button names are like 'run policy value'
,'database'
If any one know about this please help me.

Thanks in advance !!

 

[laks143]

additional information :
vb script is written in Mainframe macro editor.
i want run the excel macro which is already opened.

 

[markdmac]

Use the macro recorder to record a macro of launching the macro you wish to run. You can then use the editor to see what the relevent code is.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.