vba issue

[needhelp2]

Hello Everybody,

Today i am again here with a query.I needs to know how i can record macro while i use any tool in excel.E.g.If i select record new macro from Tools option and select any tool from control tool box "http://www.imageupload.org/?d=C058D1AE1" & operate it manually then during that when i select tool then macro recorder seems disable.But as i click any on cells of sheet then it records that cell activity.It's not recording tool performance.May i know how i can record performed activities for that selected tool as well?

http://www.imageupload.org/?d=C058D1AE1

Regards,
Smith

 

[Andrew Poulsom]

May i know how i can record performed activities for that selected tool as well?

Sorry, you can't. The macro recorder doesn't record everything. What is it that you want to do in VBA exactly?

 

[needhelp2]

infact i was using web browser script in that.once web open then it will input values in web fields from excel sheet.

 

[Hermanito]

If you want to automate different programs working together, you can look into tools like AutoIT. You can record, or program from scratch, macro's that can operate any window of any program inside Windows.

It's freeware, it's great, but you'd have to learn a new language, and also take into account the multitude of issues you can have when writing macros on that level (e.g.: moving or activating another window during the macro can/will mess up the result, from annoying to disastrous... so take care when using it)

 

[needhelp2]

Thanks alot dear Hermanito.Your advice is really helpful for me in this regard.