{"id":17636,"date":"2022-07-09T21:05:09","date_gmt":"2022-07-09T21:05:09","guid":{"rendered":"http:\/\/vmlogger.com\/excel\/?page_id=17636"},"modified":"2022-09-20T10:56:40","modified_gmt":"2022-09-20T10:56:40","slug":"excel-macro-tutorial","status":"publish","type":"page","link":"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/","title":{"rendered":"Tutorials"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; background_enable_color=&#8221;off&#8221; custom_padding=&#8221;0px||0px||true|false&#8221; top_divider_color=&#8221;#FEC30F&#8221; da_disable_devices=&#8221;off|off|off&#8221; border_width_bottom=&#8221;5px&#8221; border_color_bottom=&#8221;#FEC30F&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; background_enable_color=&#8221;off&#8221; custom_padding=&#8221;||10px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.17.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.17.6&#8243; _dynamic_attributes=&#8221;content&#8221; _module_preset=&#8221;default&#8221; header_font=&#8221;|600||on|||||&#8221; header_text_align=&#8221;center&#8221; header_text_color=&#8221;#0C71C3&#8243; header_font_size=&#8221;40px&#8221; global_colors_info=&#8221;{}&#8221;]@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IjxoMT4iLCJhZnRlciI6IjwvaDE+In19@[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.17.4&#8243; custom_padding=&#8221;0px|0px|0px|0px|true|true&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row column_structure=&#8221;2_3,1_3&#8243; admin_label=&#8221;row&#8221; _builder_version=&#8221;4.17.4&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;4.17.4&#8243; custom_padding=&#8221;|0px||0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<\/p>\n<!-- Widget Shortcode --><div id=\"adsensewidget-8\" class=\"widget widget_adsensewidget widget-shortcode area-arbitrary \"><h2 class=\"widgettitle\">.<\/h2>\t\t<div style=\"overflow: hidden;\">\n\t\t\t<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2726952725665382\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- HorizontalAd-ForCategoryPages -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-2726952725665382\"\r\n     data-ad-slot=\"4097563778\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\t\t\t<div class=\"clearfix\"><\/div>\n\t\t<\/div>\n\t<\/div><!-- \/Widget Shortcode -->\n<p>[\/et_pb_text][et_pb_accordion _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; body_line_height=&#8221;1.9em&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_accordion_item title=&#8221;Advanced Excel VBA Tutorial&#8221; open=&#8221;on&#8221; open_toggle_background_color=&#8221;#FFFFFF&#8221; closed_toggle_text_color=&#8221;#FFFFFF&#8221; closed_toggle_background_color=&#8221;#30657F&#8221; icon_color=&#8221;#FFFFFF&#8221; toggle_icon=&#8221;&#x3e;||divi||400&#8243; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;30px&#8221; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; body_font=&#8221;||||||||&#8221; body_font_size=&#8221;17px&#8221; body_ul_font=&#8221;|600|||||||&#8221; global_colors_info=&#8221;{}&#8221; toggle_level=&#8221;h3&#8243; toggle_font=&#8221;|600|||||||&#8221;]<\/p>\n<ol class=\"ultutorial\">\n<li><a href=\"\/excel\/qc-connect-excel-macro\/\" target=\"_blank\" rel=\"noopener\">Connect to HP QC using Excel VBA<\/a><\/li>\n<li><a href=\"\/excel\/create-folder-in-qc-testlab\/\" target=\"_blank\" rel=\"noopener\">Create Folder Structure in Test Lab and Pull test Cases from Test Plan<\/a><\/li>\n<li><a href=\"\/excel\/download-test-cases-from-qc\/\" target=\"_blank\" rel=\"noopener\">Download Test Cases from HP QC with Design Steps<\/a><\/li>\n<li><a href=\"\/excel\/download-test-cases-from-qc\/#with_steps\" target=\"_blank\" rel=\"noopener\">Download Test Cases from HP QC without Design Steps<\/a><\/li>\n<li><a href=\"\/excel\/2011\/12\/how-to-connect-to-access-database-excel-macro\/\" target=\"_blank\" rel=\"noopener\">How to connect to Access Database \u2013 ADO Connection String<\/a><\/li>\n<li><a href=\"\/excel\/2011\/11\/sql-connection-string\/\" target=\"_blank\" rel=\"noopener\">SQL Connection using Excel Macros<\/a><\/li>\n<li><a href=\"\/excel\/2011\/11\/oracle-connection-string-in-vba\/\" target=\"_blank\" rel=\"noopener\">Oracle Connection String in VBA<\/a><\/li>\n<li><a href=\"\/excel\/2014\/07\/record-set-from-database-excel-macro\/\" target=\"_blank\" rel=\"noopener\">Query Database and Spreading the Records in Excel \u2013 VBA Code<\/a><\/li>\n<li><a href=\"\/excel\/2011\/12\/record-count-property\/\" target=\"_blank\" rel=\"noopener\">ADO RecordCount Property \u2013 RecordSet Object<\/a><\/li>\n<li><a href=\"\/excel\/2016\/12\/google-maps-distance-matrix-in-excel-vba\/\" target=\"_blank\" rel=\"noopener\">Calculate distance between two places in Excel [With Fun]<\/a><\/li>\n<li><a href=\"\/excel\/2016\/12\/google-map-in-excel-using-vba\/\" target=\"_blank\" rel=\"noopener\">VBA to Add Static Google Map in Excel Sheet<\/a><\/li>\n<\/ol>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8221;40 Useful Excel VBA Code with Examples&#8221; closed_toggle_text_color=&#8221;#FFFFFF&#8221; closed_toggle_background_color=&#8221;#0C71C3&#8243; icon_color=&#8221;#FFFFFF&#8221; toggle_icon=&#8221;&#x3e;||divi||400&#8243; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;30px&#8221; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; body_font=&#8221;||||||||&#8221; body_font_size=&#8221;17px&#8221; body_ul_font=&#8221;|600|||||||&#8221; global_colors_info=&#8221;{}&#8221; toggle_level=&#8221;h3&#8243; toggle_font=&#8221;|600|||||||&#8221; open=&#8221;off&#8221;]<\/p>\n<p><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-create-a-New-Excel-Workbook\" target=\"_blank\" rel=\"noopener\">1. Create a New Excel Workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-open-an-existing-excel-workbook\" target=\"_blank\" rel=\"noopener\">2. Open an existing Excel Workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-close-a-workbook-without-saving-the-changes\" target=\"_blank\" rel=\"noopener\">3. Close a workbook without saving the changes using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-close-a-workbook-without-saving-the-changes\" target=\"_blank\" rel=\"noopener\">4. Close a workbook by saving the changes using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-save-or-saveAs-a-workbook\" target=\"_blank\" rel=\"noopener\">5. Save or SaveAs a workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-delete-a-workbook\" target=\"_blank\" rel=\"noopener\">6. Delete a workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-add-a-new-worksheet-in-a-workbook\" target=\"_blank\" rel=\"noopener\">7. Add a new worksheet in a workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-add-a-worksheet-at-a-specified-position\" target=\"_blank\" rel=\"noopener\">8. Add a worksheet at a specified position using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-rename-a-worksheet\" target=\"_blank\" rel=\"noopener\">9. Rename a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-delete-a-worksheet\" target=\"_blank\" rel=\"noopener\">10. Delete a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-change-the-tab-color-of-a-worksheet\" target=\"_blank\" rel=\"noopener\">11. Change the tab color of a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-copy-a-worksheet-within-same-workbook\" target=\"_blank\" rel=\"noopener\">12. Copy a worksheet within same workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-copy-a-worksheet-as-a-new-workbook\" target=\"_blank\" rel=\"noopener\">13. Copy a worksheet as a new Workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-copy-a-worksheet-by-providing-sheet-name-of-your-choice\" target=\"_blank\" rel=\"noopener\">14. Copy a worksheet by providing sheet name of your choice using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-hide-a-worksheet\" target=\"_blank\" rel=\"noopener\">15. Hide a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-hide-all-worksheets-except-activeSheet\" target=\"_blank\" rel=\"noopener\">16. Hide all worksheets except activeSheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-unhide-a-worksheet\" target=\"_blank\" rel=\"noopener\">17. Unhide a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-unhide-all-worksheets-in-a-workbook\" target=\"_blank\" rel=\"noopener\">18. Unhide all worksheets in a workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-check-if-a-sheet-exists\" target=\"_blank\" rel=\"noopener\">19. Check if a sheet with particular name exists in a workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-1-of-2#vba-to-sort-all-worksheet-alphabetically\" target=\"_blank\" rel=\"noopener\">20. Sort all worksheet alphabetically using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-insert-a-row-in-worksheet\" target=\"_blank\" rel=\"noopener\">21. Insert a row in a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-insert-a-column-in-worksheet\" target=\"_blank\" rel=\"noopener\">22. Insert a column in a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-delete-a-row-in-worksheet\" target=\"_blank\" rel=\"noopener\">23. Delete a row in a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-delete-a-column-in-worksheet\" target=\"_blank\" rel=\"noopener\">24. Delete a column in a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-hide-a-row-in-worksheet\" target=\"_blank\" rel=\"noopener\">25. Hide a row in worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-hide-a-column-in-worksheet\" target=\"_blank\" rel=\"noopener\">26. Hide a column in worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-unhide-a-row-in-worksheet\" target=\"_blank\" rel=\"noopener\">27. Unhide a row in worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-unhide-a-column-in-worksheet\" target=\"_blank\" rel=\"noopener\">28. Unhide a column in worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-copy-and-insert-copied-row-before-a-specific-row\" target=\"_blank\" rel=\"noopener\">29. Copy and insert copied row before a specific row using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-copy-and-insert-copied-column-before-a-specific-column\" target=\"_blank\" rel=\"noopener\">30. Copy and insert copied column before a specific column using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-protect-a-worksheet-without-any-password\" target=\"_blank\" rel=\"noopener\">31. Protect a worksheet without any password using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-protect-a-worksheet-with-password\" target=\"_blank\" rel=\"noopener\">32. Protect a worksheet with a password using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-unprotect-a-protected-worksheet\" target=\"_blank\" rel=\"noopener\">33. Unprotect a protected worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-unprotect-a-password-protected-worksheet\" target=\"_blank\" rel=\"noopener\">34. Unprotect a password protected worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-protect-a-workbook-with-password\" target=\"_blank\" rel=\"noopener\">35. Protect a workbook with password using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-open-a-password-protected-workbook\" target=\"_blank\" rel=\"noopener\">36. Open a password protected workbook using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-clear-contents-of-a-Range-without-clearing-formatting\" target=\"_blank\" rel=\"noopener\">37. Clear contents of a Range without clearing formatting using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-clear-content-of-a-range-with-formatting\" target=\"_blank\" rel=\"noopener\">38. Clear content of a range with formatting using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-clear-contents-of-worksheet\" target=\"_blank\" rel=\"noopener\">39. Clear contents of a worksheet using Excel Macro<\/a><br \/><a href=\"\/excel\/2018\/06\/40-useful-excel-macro-examples-for-beginners-part-2-of-2#vba-to-clear-all-the-comments\" target=\"_blank\" rel=\"noopener\">40. Clear all the comments using Excel Macro<\/a><\/p>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8221;Send Email Tutorials&#8221; closed_toggle_text_color=&#8221;#FFFFFF&#8221; closed_toggle_background_color=&#8221;#FEC30F&#8221; icon_color=&#8221;#FFFFFF&#8221; toggle_icon=&#8221;&#x3f;||divi||400&#8243; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;30px&#8221; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; body_font=&#8221;||||||||&#8221; body_font_size=&#8221;17px&#8221; body_ul_font=&#8221;|600|||||||&#8221; global_colors_info=&#8221;{}&#8221; toggle_level=&#8221;h3&#8243; toggle_font=&#8221;|600|||||||&#8221; open=&#8221;off&#8221;]<\/p>\n<ol class=\"ultutorial\">\n<li><a href=\"\/excel\/send-worksheet-as-a-pdf-attachment\/\" target=\"_blank\" rel=\"noopener\">Send Sheet as a PDF attachment in Email<\/a><\/li>\n<li><a href=\"\/excel\/mail-chart-as-image-from-outlook-vba-code\" target=\"_blank\" rel=\"noopener\">How to Send Chart Picture as an Attachment in email<\/a><\/li>\n<li><a href=\"\/excel\/mail-chart-as-image-from-outlook-vba-code\" target=\"_blank\" rel=\"noopener\">How to Send Chart Picture embedded in email Body<\/a><\/li>\n<li><a href=\"\/excel\/send-more-than-one-sheet\/\" target=\"_blank\" rel=\"noopener\">How to Send more than one sheet of the current workbook in email(Send more than One Sheet)<\/a><\/li>\n<li><a href=\"\/excel\/mail-one-sheet\/\" target=\"_blank\" rel=\"noopener\">How to Send email with the Active Sheet attached in the mail. (Send One Sheet)<\/a><\/li>\n<li><a href=\"\/excel\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/\" target=\"_blank\" rel=\"noopener\">How to Send an Email using Excel Macro from Gmail or Yahoo<\/a><\/li>\n<li><a href=\"\/excel\/how-to-send-email-by-excel-macro-from-outlook\/\" target=\"_blank\" rel=\"noopener\">How to send email from Excel Macro from Outlook<\/a><\/li>\n<li><a href=\"\/excel\/how-to-send-activeworkbook-as-attachment-in-email\/\" target=\"_blank\" rel=\"noopener\">How to Send ActiveWorkbook as attachment in Email<\/a><\/li>\n<li><a href=\"\/excel\/send-multiple-emails\/\" target=\"_blank\" rel=\"noopener\">Excel Macro Application to Send Multiple Emails (Download available)<\/a><\/li>\n<li><a href=\"\/excel\/send-email-automatically\/\" target=\"_blank\" rel=\"noopener\">How to Send Email Automatically from Excel (Download available in the Article)<\/a><\/li>\n<li><a href=\"\/excel\/insert-outlook-signature-in-email\/\" target=\"_blank\" rel=\"noopener\">How to insert Outlook Signature in Email by Excel VBA<\/a><\/li>\n<li><a href=\"\/excel\/sending-a-html-email-using-word-email-template-and-excel-macros\/\" target=\"_blank\" rel=\"noopener\">How to Send a HTML Email using Word Email Template using Excel Macro<\/a><\/li>\n<li><a href=\"\/excel\/send-image-of-a-range-from-excel-embedded-in-mail-inline-image-in-mail\/\" target=\"_blank\" rel=\"noopener\">Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]<\/a><\/li>\n<\/ol>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8221;VBA Programming Tutorial&#8221; closed_toggle_text_color=&#8221;#FFFFFF&#8221; closed_toggle_background_color=&#8221;#7EBDC4&#8243; icon_color=&#8221;#FFFFFF&#8221; toggle_icon=&#8221;&#x3f;||divi||400&#8243; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;30px&#8221; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; body_font=&#8221;||||||||&#8221; body_font_size=&#8221;17px&#8221; body_ul_font=&#8221;|600|||||||&#8221; global_colors_info=&#8221;{}&#8221; toggle_level=&#8221;h3&#8243; toggle_font=&#8221;|600|||||||&#8221; open=&#8221;off&#8221;]<\/p>\n<ol class=\"ultutorial\">\n<li><a href=\"\/excel\/excel-programming-vba-variable\/\" target=\"_blank\" rel=\"noopener\">VBA Programming : Variables in Excel VBA<\/a><\/li>\n<li><a href=\"\/excel\/option-explicit-declaration-of-variables-in-macro\/\" target=\"_blank\" rel=\"noopener\">Implicit and Explicit declaration of variables in Excel Macro<\/a><\/li>\n<li><a href=\"\/excel\/declaring-multiple-variables-with-one-dim-statement\/\" target=\"_blank\" rel=\"noopener\">Important : Declaring multiple Variables with one Dim Statement<\/a><\/li>\n<li><a href=\"\/excel\/for-loop-excel-macro\/\" target=\"_blank\" rel=\"noopener\">For Next Loop in Excel Macro<\/a><\/li>\n<li><a href=\"\/excel\/while-loop-in-excel-vba\/\" target=\"_blank\" rel=\"noopener\">While Loop and Do While Loop in Excel VBA<\/a><\/li>\n<li><a href=\"\/excel\/vba-programming-if-then-statement\/\" target=\"_blank\" rel=\"noopener\">VBA Programming : If Then Statements \/ If else Statements<\/a><\/li>\n<li><a href=\"\/excel\/select-case-statement\/\" target=\"_blank\" rel=\"noopener\">VBA Programming : Decision \u2013 Select Case in Excel VBA<\/a><\/li>\n<\/ol>\n<p>[\/et_pb_accordion_item][et_pb_accordion_item title=&#8221;Tutorial for Beginners&#8221; open_toggle_background_color=&#8221;#FFFFFF&#8221; closed_toggle_text_color=&#8221;#FFFFFF&#8221; closed_toggle_background_color=&#8221;#FF4D53&#8243; icon_color=&#8221;#FFFFFF&#8221; toggle_icon=&#8221;&#x3f;||divi||400&#8243; use_icon_font_size=&#8221;on&#8221; icon_font_size=&#8221;30px&#8221; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; body_font=&#8221;||||||||&#8221; body_font_size=&#8221;17px&#8221; body_ul_font=&#8221;|600|||||||&#8221; global_colors_info=&#8221;{}&#8221; toggle_level=&#8221;h3&#8243; toggle_font=&#8221;|600|||||||&#8221; open=&#8221;off&#8221;]<\/p>\n<ol class=\"ultutorial\">\n<li><a href=\"\/excel\/getting-started-with-excel-macro-1\/\" target=\"_blank\" rel=\"noopener\">What is Excel Macro ?<\/a><\/li>\n<li><a href=\"\/excel\/getting-started-with-excel-macro-1\/\" target=\"_blank\" rel=\"noopener\">How to Record \/ Run Excel Macro ?<\/a><\/li>\n<li><a href=\"\/excel\/add-developer-tab-in-excel-2010-and-2007\/\" target=\"_blank\" rel=\"noopener\">How Add Developer\u2019s Tab in Excel 2007 \/ 2010<\/a><\/li>\n<li><a href=\"\/excel\/getting-started-with-excel-macro-2\/\" target=\"_blank\" rel=\"noopener\">How to add different types of controls like Text Box, Radio button, button etc. in Excel<\/a><\/li>\n<li><a href=\"\/excel\/visual-basic-editor\/\" target=\"_blank\" rel=\"noopener\">Visual Basic Editor in Excel<\/a><\/li>\n<li><a href=\"\/excel\/properties-window-in-the-visual-basic-editor-of-excel\/\" target=\"_blank\" rel=\"noopener\">VBA Control Property<\/a><\/li>\n<li><a href=\"\/excel\/how-to-create-a-simple-macro\/\" target=\"_blank\" rel=\"noopener\">How to write Excel Macro \u2013 Your First Excel Macro<\/a><\/li>\n<li><a href=\"\/excel\/debug-vba-code\/\" target=\"_blank\" rel=\"noopener\">How to Run you code in Debug Mode?<\/a><\/li>\n<li><a href=\"\/excel\/debug-vba-code\/\" target=\"_blank\" rel=\"noopener\">What is Break Point and how to use it?<\/a><\/li>\n<li><a href=\"\/excel\/debug-vba-code\/\" target=\"_blank\" rel=\"noopener\">What is Compile Error?<\/a><\/li>\n<li><a href=\"\/excel\/excel-macro-tutorial-excel-form\/\" target=\"_blank\" rel=\"noopener\">Excel Macro Tutorial : Excel User Form<\/a><\/li>\n<li><a href=\"\/excel\/use-of-spin-button-in-excel\/\" target=\"_blank\" rel=\"noopener\">VBA Spin Button<\/a><\/li>\n<li><a href=\"\/excel\/toggle-button-in-excel\/\" target=\"_blank\" rel=\"noopener\">Toggle Button in Excel<\/a><\/li>\n<li><a href=\"\/excel\/excel-macro-tutorial-combobox-in-excel-macro\/\" target=\"_blank\" rel=\"noopener\">ComboBox \/ Drop Down List In Excel<\/a><\/li>\n<li><a href=\"\/excel\/excel-macro-tutorial-how-to-use-listbox-in-excel\/\" target=\"_blank\" rel=\"noopener\">ListBox In Excel<\/a><\/li>\n<li><a href=\"\/excel\/open-workbook-using-vba\/\" target=\"_blank\" rel=\"noopener\">How to Open Excel Workbook using Excel Macro<\/a><\/li>\n<li><a href=\"\/excel\/range-object-tutorial-in-excel-macro\/\" target=\"_blank\" rel=\"noopener\">Using RANGE Object in Excel Macro<\/a><\/li>\n<li><a href=\"\/excel\/cells-and-range\/\" target=\"_blank\" rel=\"noopener\">What is difference between CELLS() and RANGE()<\/a><\/li>\n<\/ol>\n<p>[\/et_pb_accordion_item][\/et_pb_accordion][et_pb_text _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<\/p>\n<!-- Widget Shortcode --><div id=\"adsensewidget-7\" class=\"widget widget_adsensewidget widget-shortcode area-arbitrary \"><h2 class=\"widgettitle\">.<\/h2>\t\t<div style=\"overflow: hidden;\">\n\t\t\t<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2726952725665382\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-format=\"autorelaxed\"\r\n     data-ad-client=\"ca-pub-2726952725665382\"\r\n     data-ad-slot=\"2165535006\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\t\t\t<div class=\"clearfix\"><\/div>\n\t\t<\/div>\n\t<\/div><!-- \/Widget Shortcode -->\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.17.4&#8243; background_color=&#8221;RGBA(255,255,255,0)&#8221; custom_padding=&#8221;|0px||0px|false|true&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;subscription&#8221; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; global_module=&#8221;244316&#8243; global_colors_info=&#8221;{}&#8221;]<\/p>\n<!-- Widget Shortcode --><div id=\"bloomwidget-4\" class=\"widget widget_bloomwidget widget-shortcode area-arbitrary \">\n\t\t\t\t<div class='et_bloom_widget_content et_bloom_make_form_visible et_bloom_optin et_bloom_optin_3' style='display: none;'>\n\t\t\t\t\t<style type=\"text\/css\">.et_bloom .et_bloom_optin_3 .et_bloom_form_content { background-color: #3b3b3b !important; } .et_bloom .et_bloom_optin_3 .et_bloom_form_container .et_bloom_form_header { background-color: #71b270 !important; } .et_bloom .et_bloom_optin_3 .wedge_edge .triangle { fill: #71b270} .et_bloom .et_bloom_optin_3 .et_bloom_form_content button { background-color: #fe664b !important; } .et_bloom .et_bloom_optin_3 .et_bloom_form_content .et_bloom_fields i { color: #fe664b !important; } .et_bloom .et_bloom_optin_3 .et_bloom_form_content .et_bloom_custom_field_radio i:before { background: #fe664b !important; } .et_bloom .et_bloom_optin_3 .et_bloom_form_content button { background-color: #fe664b !important; } .et_bloom .et_bloom_optin_3 .et_bloom_form_container h2, .et_bloom .et_bloom_optin_3 .et_bloom_form_container h2 span, .et_bloom .et_bloom_optin_3 .et_bloom_form_container h2 strong { font-family: \"Open Sans\", Helvetica, Arial, Lucida, sans-serif; }.et_bloom .et_bloom_optin_3 .et_bloom_form_container p, .et_bloom .et_bloom_optin_3 .et_bloom_form_container p span, .et_bloom .et_bloom_optin_3 .et_bloom_form_container p strong, .et_bloom .et_bloom_optin_3 .et_bloom_form_container form input, .et_bloom .et_bloom_optin_3 .et_bloom_form_container form button span { font-family: \"Open Sans\", Helvetica, Arial, Lucida, sans-serif; } .et_bloom .et_bloom_form_container.et_bloom_rounded input { border-radius: 50px !important; background-color: #71b270 !important; color: white !important; font-size:25px !important; } .et_bloom .et_bloom_form_container.et_bloom_rounded input:hover { letter-spacing:2px; cursor:pointer;} form{border-style: none !important; border-width: 0px !important;}<\/style>\n\t\t\t\t\t<div class='et_bloom_form_container with_edge wedge_edge et_bloom_rounded et_bloom_form_text_dark'>\n\t\t\t\t\t\t\n\t\t\t<div class=\"et_bloom_form_container_wrapper clearfix\">\n\t\t\t\t<div class=\"et_bloom_header_outer\">\n\t\t\t\t\t<div class=\"et_bloom_form_header et_bloom_header_text_light\">\n\t\t\t\t\t\t<img decoding=\"async\" width=\"610\" height=\"480\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/book-cover-transparent-background-triangle-min-2-1-min-610x480.png\" class=\" et_bloom_image_slideup et_bloom_image has-transparency\" alt=\"\" srcset=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/book-cover-transparent-background-triangle-min-2-1-min-610x480.png 610w, https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/08\/book-cover-transparent-background-triangle-min-2-1-min-480x378.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 610px, 100vw\" data-has-transparency=\"true\" data-dominant-color=\"c3aebd\" style=\"--dominant-color: #c3aebd;\" \/>\n\t\t\t\t\t\t<div class=\"et_bloom_form_text\">\n\t\t\t\t\t\t<h1 style=\"color: #ffffff; text-align: center;\">Get a FREE e-Book<\/h1><p style=\"text-align: center;\"><span style=\"color: #ffffff; font-family: 'Open Sans', Arial, sans-serif; font-size: 16px; text-align: center; background-color: #71b270;\">With over\u00a0<\/span><span class=\"fusion-tooltip tooltip-shortcode\" style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 16px; text-size-adjust: 100%; vertical-align: baseline; background: #71b270; color: #ffffff; font-family: 'Open Sans', Arial, sans-serif; text-align: center;\" title=\"\" data-animation=\"\" data-delay=\"0\" data-placement=\"top\" data-title=\"\" data-toggle=\"tooltip\" data-trigger=\"hover\" data-original-title=\"\"><span style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; text-size-adjust: 100%; vertical-align: baseline; background: transparent; font-weight: bold;\"><span style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; text-size-adjust: 100%; vertical-align: baseline; background: transparent; color: #008000;\">50,000+<\/span>\u00a0readers and counting<\/span><\/span><span style=\"color: #ffffff; font-family: 'Open Sans', Arial, sans-serif; font-size: 16px; text-align: center; background-color: #71b270;\">\u00a0Join NOW and get a\u00a0<\/span><span style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; font-size: 16px; text-size-adjust: 100%; vertical-align: baseline; background: #71b270; font-family: 'Open Sans', Arial, sans-serif; text-align: center; color: #ff6600;\"><span style=\"box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; text-size-adjust: 100%; vertical-align: baseline; background: transparent; font-weight: bold;\">FREE E-book\u00a0<\/span><\/span><span style=\"color: #ffffff; font-family: 'Open Sans', Arial, sans-serif; font-size: 16px; text-align: center; background-color: #71b270;\">to download !!<\/span><\/p>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"et_bloom_form_content et_bloom_1_field et_bloom_bottom_stacked et_bloom_custom_html_form\" data-optin_id=\"optin_3\" data-service=\"custom_form\" data-list_id=\"custom_form\" data-page_id=\"0\" data-account=\"custom_form\">\n\t\t\t\t\t<form style=\"border:1px solid #ccc;padding:3px;text-align:center;\" action=\"https:\/\/app.feedpress.com\/e\/mailverify?feed_id=excel\" method=\"post\" target=\"popupwindow\" onsubmit=\"window.open('https:\/\/app.feedpress.com\/e\/mailverify?feed_id=excel', 'popupwindow', 'scrollbars=yes,width=550,height=520');return true\">\r\n\r\n<input type=\"hidden\" value=\"excel\" name=\"uri\"\/><input type=\"hidden\" name=\"loc\" value=\"en_US\"\/>\r\n<input type=\"submit\" value=\"DOWNLOAD\" \/>\r\n<\/form>\n\t\t\t\t\t<div class=\"et_bloom_success_container\">\n\t\t\t\t\t\t<span class=\"et_bloom_success_checkmark\"><\/span>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<h2 class=\"et_bloom_success_message\">You have Successfully Subscribed!<\/h2>\n\t\t\t\t\t\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<span class=\"et_bloom_close_button\"><\/span>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div><\/div><!-- \/Widget Shortcode -->\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;]<\/p>\n<!-- Widget Shortcode --><div id=\"adsensewidget-6\" class=\"widget widget_adsensewidget widget-shortcode area-arbitrary \"><h2 class=\"widgettitle\">.<\/h2>\t\t<div style=\"overflow: hidden;\">\n\t\t\t<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2726952725665382\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- SideBar-Small -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-2726952725665382\"\r\n     data-ad-slot=\"6296351701\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\t\t\t<div class=\"clearfix\"><\/div>\n\t\t<\/div>\n\t<\/div><!-- \/Widget Shortcode -->\n<p>[\/et_pb_text][et_pb_text ul_type=&#8221;circle&#8221; module_class=&#8221;pa-blog-sidebar-list&#8221; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; link_text_color=&#8221;#FFFFFF&#8221; link_line_height=&#8221;2.2em&#8221; header_text_color=&#8221;#FFFFFF&#8221; header_2_font=&#8221;|600|||||||&#8221; header_2_text_align=&#8221;center&#8221; header_2_text_color=&#8221;#FFFFFF&#8221; header_2_font_size=&#8221;30px&#8221; header_2_line_height=&#8221;2em&#8221; background_color=&#8221;#71b270&#8243; custom_margin=&#8221;15px||15px||true|false&#8221; custom_padding=&#8221;|5px||20px|false|false&#8221; global_module=&#8221;18527&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<!-- Widget Shortcode -->\n\t\t<div id=\"recent-posts-13\" class=\"widget widget_recent_entries widget-shortcode area-arbitrary \">\n\t\t<h2 class=\"widgettitle\">Recent Articles<\/h2>\n\t\t<ul>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/dynamic-arrays-and-spill-functions-in-excel-a-beginners-guide\/\">Dynamic Arrays and Spill Functions in Excel: A Beginner&#8217;s Guide<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/how-to-declare-a-public-variable-in-vba\/\">How to Declare a Public Variable in VBA<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/how-to-copy-content-from-word-using-vba\/\">How to Copy content from Word using VBA<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/how-to-connect-to-access-database-excel-macro\/\">How to connect to Access Database &#8211; ADO Connection String<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/protect-unprotect-sheet-using-vba\/\">Excel Macro : Excel VBA code to Protect OR UnProtect Sheet<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t<\/ul>\n\n\t\t<\/div><!-- \/Widget Shortcode -->\n<p>[\/et_pb_text][et_pb_blog fullwidth=&#8221;off&#8221; posts_number=&#8221;3&#8243; include_categories=&#8221;1682&#8243; use_manual_excerpt=&#8221;off&#8221; excerpt_length=&#8221;120&#8243; show_author=&#8221;off&#8221; show_date=&#8221;off&#8221; show_categories=&#8221;off&#8221; show_pagination=&#8221;off&#8221; masonry_tile_background_color=&#8221;rgba(113,178,112,0.15)&#8221; admin_label=&#8221;Blog&#8221; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; header_text_align=&#8221;center&#8221; body_text_align=&#8221;center&#8221; body_text_color=&#8221;rgba(0,0,0,0.71)&#8221; meta_font=&#8221;|300|||||||&#8221; meta_text_color=&#8221;#000000&#8243; meta_letter_spacing=&#8221;3px&#8221; read_more_font=&#8221;|600||on|||||&#8221; read_more_text_color=&#8221;#E09900&#8243; read_more_font_size=&#8221;16px&#8221; min_height_tablet=&#8221;400px&#8221; min_height_phone=&#8221;400px&#8221; min_height_last_edited=&#8221;off|desktop&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;||||true|true&#8221; custom_padding_tablet=&#8221;5%|5%|5%|5%|true|true&#8221; custom_padding_phone=&#8221;5%|5%|5%|5%|true|true&#8221; custom_padding_last_edited=&#8221;off|desktop&#8221; body_text_color_tablet=&#8221;#545454&#8243; body_text_color_phone=&#8221;#545454&#8243; body_text_color_last_edited=&#8221;on|desktop&#8221; custom_css_featured_image=&#8221;padding: 10px 10px 10px;&#8221; border_color_all=&#8221;#71b270&#8243; global_module=&#8221;17893&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; custom_css_after__hover_enabled=&#8221;off|hover&#8221; custom_css_title__hover_enabled=&#8221;off|hover&#8221; custom_css_content__hover_enabled=&#8221;off|hover&#8221; custom_css_read_more__hover_enabled=&#8221;off|hover&#8221; transform_styles__hover_enabled=&#8221;off|hover&#8221; transform_scale__hover_enabled=&#8221;off|hover&#8221; transform_translate__hover_enabled=&#8221;off|hover&#8221; transform_rotate__hover_enabled=&#8221;off|hover&#8221; transform_skew__hover_enabled=&#8221;off|hover&#8221; transform_origin__hover_enabled=&#8221;off|hover&#8221; header_text_color__hover_enabled=&#8221;off|hover&#8221;][\/et_pb_blog][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p><!-- Widget Shortcode --><div id=\"adsensewidget-8\" class=\"widget widget_adsensewidget widget-shortcode area-arbitrary \"><h2 class=\"widgettitle\">.<\/h2>\t\t<div style=\"overflow: hidden;\">\n\t\t\t<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2726952725665382\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- HorizontalAd-ForCategoryPages -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-2726952725665382\"\r\n     data-ad-slot=\"4097563778\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\t\t\t<div class=\"clearfix\"><\/div>\n\t\t<\/div>\n\t<\/div><!-- \/Widget Shortcode --> Connect to HP QC using Excel VBA Create Folder Structure in Test Lab and Pull test Cases from Test Plan Download Test Cases from HP QC with Design Steps Download Test Cases from HP QC without Design Steps How to connect to Access Database \u2013 ADO Connection String SQL Connection using Excel Macros [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v21.9.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tutorials - Let&#039;s excel in Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tutorials\" \/>\n<meta property=\"og:description\" content=\"Connect to HP QC using Excel VBA Create Folder Structure in Test Lab and Pull test Cases from Test Plan Download Test Cases from HP QC with Design Steps Download Test Cases from HP QC without Design Steps How to connect to Access Database \u2013 ADO Connection String SQL Connection using Excel Macros [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-20T10:56:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/\",\"name\":\"Tutorials - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2022-07-09T21:05:09+00:00\",\"dateModified\":\"2022-09-20T10:56:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorials\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tutorials - Let&#039;s excel in Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/","og_locale":"en_US","og_type":"article","og_title":"Tutorials","og_description":"Connect to HP QC using Excel VBA Create Folder Structure in Test Lab and Pull test Cases from Test Plan Download Test Cases from HP QC with Design Steps Download Test Cases from HP QC without Design Steps How to connect to Access Database \u2013 ADO Connection String SQL Connection using Excel Macros [&hellip;]","og_url":"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_modified_time":"2022-09-20T10:56:40+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@learnexcelmacro","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/","url":"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/","name":"Tutorials - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2022-07-09T21:05:09+00:00","dateModified":"2022-09-20T10:56:40+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/excel-macro-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Tutorials"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"]}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/pages\/17636"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=17636"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/pages\/17636\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=17636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}