MS Office Software Training Updates

If you are New to VBA Macro for Excel Automation, please follow step by step you can automation your Task.

Step First - Enable the Developer Tab (This Tab is only for Macro Development)

Goto -> Options ->Customize Rippon -> Enable "DEVELOPER" 

once you're done, you can find additional Tab name called Developer.

Step Two - Record Macro and Shortcut key Creation

In the Developer tab, you have an option called Record Macro. once you clicked that -> you will see another window to give Shortcut Key. (Conditions to follow while giving shortcut key - Shortcut key should not be a Keyboard Short cut keys because using keyboard shortcuts system won't work as expected).

Step Three - Record your Activities

Once we are done with the Shortcut Key Creation System, start to record your actions (Your actions should be only keyboard actions mouse actions will not record) 

Important Note: Only Excel Window Keyboard actions record, Keyboard actions can perform whatever we want

Step Four - Stop Recording

We need to stop the recording once we are done with our keyboard actions, in the Developer tab you have an option to STOP (Same button where we select the Record Macro)

Step Five - Run Macro (What we Recorded)

Once we are done with Everything, this is the Output or Final step Press Shortcut key we created while recording.

Hi Friends, I am trying to bulid a macro for Web page automation where I am not getting how to write a code for that. In HTML source page there is no any id,class to get element, the tag is 

<a href="javascript:;" onclick="enableMandate('MjQ9Kio9ZW5hYmxl')">Enable</a> 

where if I click enable button the pop up message will come are you sure you need to enable I need to click yes. So, I have to do it for 1000 items, hence I am trying to build a VBA code.

Can any any one help me, it is emergency? read less