What is your favorite VBS editor to write scripts?
If we search vb editor on Google you would find thousand of suggestions like notepad++,vbsedit and many more fancy IDE.But sometimes there are situations, like due to organization compliance policies or some other reasons, that we don’t have access to these editors .Then what to do in that case of scenarios.
“Don’t use a lot where a little will do.” -Proverb
Thus we have to achieve maximum out of what we have.
Solution is utilizing the inbuilt feature of developer tab in Microsoft excel to code our vbs/vba scripts.
We thought of sharing the same with you all, follow us on Fb,G+,Twitter for more updates.
Steps:-
1. Open excel instance.
2. Look for “Developer tab” -> Visual Basic
Note: – Incase “Developer tab” is not available in the excel ribbon, then, click on Microsoft icon on the top left corner of excel ->Excel Options -> Popular -> check the “Show Developer tab in the ribbon” > OK
We can directly launch Visual basic IDE by using ALT+ F11,after launching the excel instance.
3. Right click on VBA project in the “project explorer “ -> Insert -> module
4. Now we ready to write our code, it provides intellisense and debugging
If we search vb editor on Google you would find thousand of suggestions like notepad++,vbsedit and many more fancy IDE.But sometimes there are situations, like due to organization compliance policies or some other reasons, that we don’t have access to these editors .Then what to do in that case of scenarios.
“Don’t use a lot where a little will do.” -Proverb
Thus we have to achieve maximum out of what we have.
Solution is utilizing the inbuilt feature of developer tab in Microsoft excel to code our vbs/vba scripts.
We thought of sharing the same with you all, follow us on Fb,G+,Twitter for more updates.
Steps:-
1. Open excel instance.
2. Look for “Developer tab” -> Visual Basic
Note: – Incase “Developer tab” is not available in the excel ribbon, then, click on Microsoft icon on the top left corner of excel ->Excel Options -> Popular -> check the “Show Developer tab in the ribbon” > OK
We can directly launch Visual basic IDE by using ALT+ F11,after launching the excel instance.
3. Right click on VBA project in the “project explorer “ -> Insert -> module
4. Now we ready to write our code, it provides intellisense and debugging
facilities(like we have watch option in UFT same is available here)
5. Save as type “Excel Macro-Enabled Workbook”
6. Run (F5) or green play icon on the ribbon panel.
Explore the other features on the panel to learn more.
Please share your views or your comments about what can be your favorite editor incase you have limited resources, other than Notepad offcourse 🙂
Learn Vbscript
Selenium