{"id":93669,"date":"2025-03-18T14:23:24","date_gmt":"2025-03-18T08:53:24","guid":{"rendered":"https:\/\/cloudfoundation.com\/blog\/?p=93669"},"modified":"2025-03-19T10:48:26","modified_gmt":"2025-03-19T05:18:26","slug":"what-is-vbscript","status":"publish","type":"post","link":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/","title":{"rendered":"What is VBScript?"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#What_is_VBScript\" >What is VBScript?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Storage_Efficiency_with_Arrays_in_VBScript\" >Storage Efficiency with Arrays in VBScript<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Working_With_Dynamic_and_Fixed_Arrays_in_VBScript\" >Working With Dynamic and Fixed Arrays in VBScript<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Implementing_and_Controlling_Loops_in_VBScript\" >Implementing and Controlling Loops in VBScript<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Implementing_For_Next_and_For_Each_Loops_in_VBScript\" >Implementing For Next and For Each Loops in VBScript<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Conditional_Logic_and_String_Functions_in_VBScript\" >Conditional Logic and String Functions in VBScript<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#String_Comparison_and_Conditional_Execution_in_VBScript\" >String Comparison and Conditional Execution in VBScript<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Implementing_Sub_and_Function_Procedures_in_VBScript\" >Implementing Sub and Function Procedures in VBScript<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Utilising_Loops_in_VBScript_for_Automating_Report_Generation\" >Utilising Loops in VBScript for Automating Report Generation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Creating_HTML_and_Excel_Reports_With_VBScript\" >Creating HTML and Excel Reports With VBScript<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<h2><span class=\"ez-toc-section\" id=\"What_is_VBScript\"><\/span><strong>What is VBScript?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>VBScript is a powerful tool for managing data and storing multiple values. VBScript can be used to automate testing tasks in tools like QTP (UFT) and Test Complete.<\/p>\n<p>As an interpreted language, VBScript doesn&#8217;t need compilation like other programming languages like C, C++ or Java do.<\/p>\n<p>By employing its Option Explicit statement and adhering to proper syntax requirements, VBScript can manage complex data structures efficiently as well as handle errors more reliably than its peers.<\/p>\n<p>Automation with VBScript can automate administrative tasks on computers, such as mapping drives or managing software inventories for multiple computers.<\/p>\n<p>Built into Windows OS and designed as an easy learning experience.<\/p>\n<p>Visual Basic was once considered to be difficult and fun, yet now VBScript makes script writing much simpler and enjoyable.<\/p>\n<p>In its full name VBScript stands for Microsoft Visual Basic Scripting edition.<\/p>\n<p><img decoding=\"async\" width=\"800\" height=\"2876\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/vbscript-arrays-and-loops.png\" alt=\"\" class=\"size-medium aligncenter\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Storage_Efficiency_with_Arrays_in_VBScript\"><\/span><strong>Storage Efficiency with Arrays in VBScript <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In VBScript, arrays offer an efficient means of storing multiple values within one variable without declaring separate variables for them separately.<\/p>\n<p>Fixed arrays have an established size; dynamic arrays offer greater flexibility by using ReDim statements to adapt their number of elements as necessary.<\/p>\n<p>Furthermore, Redim Preserve statements ensure existing data remains undamaged when resizing an array.<\/p>\n<p>VBScript&#8217;s UBound function makes data management simpler by retrieving an array&#8217;s upper limit, making data management much simpler.<\/p>\n<p>When choosing between fixed or dynamic arrays for data management purposes, each application&#8217;s requirements need to be taken into consideration, with fixed arrays being suitable for fixed sizes of information while dynamic ones allow adaptability for changing requirements.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Working_With_Dynamic_and_Fixed_Arrays_in_VBScript\"><\/span><strong>Working With Dynamic and Fixed Arrays in VBScript<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The UBound function determines the upper bound for arrays that is set at 5, using an iterative loop from zero to five.<\/p>\n<p>Echo statement prints each element in the loop. When resizing an array with existing data, use ReDim statement carefully as data loss could occur without Preserve keyword applied.<\/p>\n<p>Fixed arrays contain fixed elements while dynamic ones expand and contract as required.<\/p>\n<p>An array named Numbers stores six values with index numbers from 0-5 for storage purposes.<\/p>\n<p>FillNumbers assigns numbers from 10-12 while AverageNumbers uses an infinite loop to compute and average all numbers within its array.<\/p>\n<p>Finally, its output displays this calculated average.<\/p>\n<p><img decoding=\"async\" width=\"800\" height=\"1940\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/vbscript-data-management.png\" alt=\"\" class=\"size-medium aligncenter\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Implementing_and_Controlling_Loops_in_VBScript\"><\/span><strong>Implementing and Controlling Loops in VBScript<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>VBScript uses the For Next loop to execute code repeatedly based on a condition. A variable is initialized as zero and incremented each iteration by one, until its value reaches 5 or less; thereafter the loop terminates by incrementing by 2.<\/p>\n<p>Utilising Step parameter allows custom increments such as increasing by 2 rather than 1.<\/p>\n<p>Exit For statements provide flexibility when controlling loop execution and improving script performance by terminating loops when certain conditions have been fulfilled &#8211; providing early loop exits when desired.<\/p>\n<p>They&#8217;re great tools for controlling loop execution and optimizing script performance!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Implementing_For_Next_and_For_Each_Loops_in_VBScript\"><\/span><strong>Implementing For Next and For Each Loops in VBScript<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A For Next loop enables the counter variable to rise or fall depending on its Step value; negative steps may be possible if provided, otherwise defaulting to 1. If no Step value is specified then defaults to 1.<\/p>\n<p>For Each loops are used to execute code for every element in a collection such as an array or folder contents, for instance when listing files using On Error Resume Next (OERN) the script continues execution regardless of any errors that arise during its run.<\/p>\n<p>Three variables-objFSO, folder and file-are declared and set using Set statement; folder is declared using an object of file system objects created and assigned through Set statement; script then iterates through all folder files by iteration using Name property to display complete pathname of files iterated through.<\/p>\n<p>One method involves retrieving hard drive information from a computer using script. In order to do this, three object variables objWMIService, objHardDisks and objDrive were declared.<\/p>\n<p>Utilizing GetObject, setting objWMIService = GetObject(&#8220;winmgmts:com-PC&#8221;) retrieves system information where &#8220;com-PC&#8221; represents computer name.<\/p>\n<p>Additionally, setting the HardDisks variable executes a query which selects all physical disks providing information regarding total and free disk space available for storage.<\/p>\n<p>The For Each Next Statement effectively processes elements within a collection. This technique can be useful in tasks like file manipulation and data retrieval from system servers.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#0095f2&#8243; background_color_gradient_end=&#8221;#7dbed8&#8243; background_color_gradient_direction=&#8221;92deg&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;73%|62%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/SS_436-_Converted_-1.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_scale=&#8221;114%|112%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;25px|-4px&#8221; transform_translate_linked=&#8221;off&#8221; width=&#8221;98.1%&#8221; custom_margin=&#8221;|7px|||false|false&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;21px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>VBScript <\/strong>Training<\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Explore Course Content&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#0C71C3&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conditional_Logic_and_String_Functions_in_VBScript\"><\/span><strong>Conditional Logic and String Functions in VBScript<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>VBScript contains various functions and conditional statements to manipulate strings and manage program flow.<\/p>\n<p>For instance, its UCASe function converts words from lowercase to uppercase while Trim removes extra spaces from strings.<\/p>\n<p>Conditional execution can be accomplished using If&#8230;Then&#8230;ElseIF&#8230;End If, which allows various actions depending on a variety of conditions to take place; additionally the InStr function helps identify substrings within strings for use as logic checks.<\/p>\n<p>VBScript supports numerous built-in constants to increase readability.<\/p>\n<p>Utilising these constants makes VBScript effective at handling decision making processes and string operations efficiently.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"String_Comparison_and_Conditional_Execution_in_VBScript\"><\/span><strong>String Comparison and Conditional Execution in VBScript<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>StrComp in VBScript compares two strings based on three arguments, such as their first string, second string and comparison mode.<\/p>\n<p>When both strings match exactly, StrComp will return zero and display an information box stating: Both strings match exactly.<\/p>\n<p>If one string is greater than another, StringCompare.vbs returns 1 and displays an appropriate message.<\/p>\n<p>Instances in which an error arise are handled using Case Else statements which display error messages when necessary.<\/p>\n<p><img decoding=\"async\" width=\"800\" height=\"2304\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/VBScript-Loop-Techniques-1.png\" alt=\"\" class=\"size-medium aligncenter\" \/><\/p>\n<p>To use it yourself, save and run StringCompare.vbs with various string inputs as soon as you want.<\/p>\n<p>By default, this function compares text in case-insensitive fashion; adding the vbTextCompare constant allows case-sensitive comparisons.<\/p>\n<p>Furthermore, using Select Case&#8230;End Select statement helps evaluate expressions and take actions according to values evaluated during this search process.<\/p>\n<p>Procedures in VBScript enhance code reuse by streamlining string comparison and conditional execution processes, making string manipulation and conditional execution faster and more cost effective.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Implementing_Sub_and_Function_Procedures_in_VBScript\"><\/span><strong>Implementing Sub and Function Procedures in VBScript<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Within the language itself, procedures enhance modularity and efficiency by breaking tasks down into modularized pieces and increasing task efficiency through task isolation.<\/p>\n<p>There are two primary categories of procedures; Sub procedures and Function procedures.<\/p>\n<p>KilosPoundsSub.vbs shows us an example of using Sub procedures without returning an output value; such as performing actions but without returning one.<\/p>\n<p>Specifically, this script takes user input at command prompt window level before calling ConvertWeight Sub procedure in order to convert weight from pounds (1 kg = 2.205 pounds).<\/p>\n<p>After clicking &#8220;OK&#8221;, a message box displaying the results will be opened and an EndScript procedure called to thank them for participating.<\/p>\n<p>A Sub procedure may then be executed using either Call statement or by providing parameters within parentheses.<\/p>\n<p><img decoding=\"async\" class=\"size-medium aligncenter\" src=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/vbscript-functions-and-logic.png\" alt=\"\" width=\"800\" height=\"2890\" \/><\/p>\n<p>Call statements allow repeated execution and modifications (e.g. changing conversion factors) without impacting other parts of a script.<\/p>\n<p>On the other hand, Function procedures in VBScript start off with Function statement and end with End Function statements respectively.<\/p>\n<p>Function procedures differ from Sub procedures by returning values; for instance, KilosPoundsFunction.vbs uses user input converted into double and passed onto a function which multiplies it by 2.205.<\/p>\n<p>Function procedures are useful for calculations that return dynamic values in message boxes, making function procedures an efficient means of dynamic calculations and returns.<\/p>\n<p>Loops also play a vital role; For instance, While&#8230;Wend loops run code repeatedly until certain conditions become true again.<\/p>\n<p>Loop1 procedure uses While&#8230;Wend&#8217;s automatic increment statements to initialize i = 1, then runs while it drops below five iterations threshold, with message box output for every iteration containing information about current iteration of Loop.<\/p>\n<p>A custom increment statement must also be implemented manually so as to prevent an infinite loop scenario from developing.<\/p>\n<p>This type of loop can be particularly effective when the number of iterations is unknown; execution continues so long as a condition holds true.<\/p>\n<p>VBScript procedures play an integral part in automating tasks such as creating text files, HTML pages and Excel sheets.<\/p>\n<p>By employing Sub and Function procedures, scripts become more organized, readable and efficient while at the same time being easier to reuse code for efficient execution.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#ff8c7c&#8221; background_color_gradient_end=&#8221;#e5ba4e&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top left&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;74%|69%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;||-5px||false|false&#8221; custom_padding=&#8221;|||2px|false|false&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/8423118_3895895.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;85.4%&#8221; custom_margin=&#8221;-31px||-24px||false|false&#8221; custom_padding=&#8221;|22px|0px||false|false&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;19px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;1.2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #000000;\"><strong>VBScript<\/strong> Online Training<\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Up Coming Batches&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#E09900&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221; background_layout=&#8221;dark&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Utilising_Loops_in_VBScript_for_Automating_Report_Generation\"><\/span><strong>Utilising Loops in VBScript for Automating Report Generation<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A while loop is used to increase variables until they meet a given condition, stopping execution when that condition no longer applies and thus terminating execution when its unmet.<\/p>\n<p>To generate HTML reports using file system objects in VBScript. Write Head and Body are separate subprocedures used to generate HTML markup; respectively.<\/p>\n<p>Write Head defines an HTML head section while Body provides body structure using headings, paragraphs and tables; this script creates an HTML report showing order details dynamically.<\/p>\n<p>Do Loop statements in VBScript offer two versions.<\/p>\n<p>Do While Condition executes only when its condition initially meets.<\/p>\n<p>Do -Loop While Condition executes at least once prior to checking its condition.<\/p>\n<p>Python scripting demonstrates this looping concept by controlling execution according to conditions, while for Excel report automation purposes VBScript scripts create and modify Excel files automatically.<\/p>\n<p>FileDelete and WriteExcelReport provide automation that enhances efficiency when it comes to dynamic reports generation using VBScript, by clearing away existing files while offering structured data entry via Excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Creating_HTML_and_Excel_Reports_With_VBScript\"><\/span><strong>Creating HTML and Excel Reports With VBScript<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>VBScript allows for the automation and creation of Excel files by adding workbooks, assigning values to cells and applying formatting.<\/p>\n<p>Furthermore, it enables alteration to cell colors, font sizes and structured data such as &#8220;Orders Placed&#8221; and &#8220;Number of Customers.&#8221;<\/p>\n<p><img decoding=\"async\" width=\"800\" height=\"2310\" src=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/vbscript-procedures-and-effieciency-1.png\" alt=\"\" class=\"size-medium aligncenter\" \/><\/p>\n<p>This script makes use of Active Cell and Entire Column formatting techniques, applies AutoFit method for text alignment purposes, and employs WriteExcelReport script for writing formatted report.<\/p>\n<p>A FileDelete subprocedure deletes old files prior to creating updated version of them.<\/p>\n<p>The While Wend statement provides an efficient looping mechanism by running code when an specified condition remains True, while Do Loop allows more flexible control by checking conditions at either end of a loop cycle.<\/p>\n<p>The Do While Condition variation only executes if its condition initially evaluates as True; while with Do-Loop While Condition execution takes place at least once prior to evaluating this condition.<\/p>\n<p>These techniques enable more efficient automation of repetitive tasks using VBScript, improving report generation and data formatting capabilities.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>VBScript has long been one of the more widely-used scripting languages, used for numerous applications like automating tasks and designing dynamic web pages to constructing standalone applications.<\/p>\n<p>While other scripting languages have emerged and seen greater adoption over time, VBScript continues to be used by developers who work within Windows-based environments.<\/p>\n<p>Because of its simplicity, compatibility with Microsoft products, and adaptability, Powershell can serve as an indispensable resource for developers looking to automate workflows and develop dynamic web experiences.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#494fff&#8221; background_color_gradient_end=&#8221;#9ea6ff&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top left&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;74%|71%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/Untitled-11.png&#8221; title_text=&#8221;Untitled-11&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_scale=&#8221;103%|103%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;11px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_padding=&#8221;|88px||||&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;19px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;1.2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/&#8221; link_option_url_new_window=&#8221;on&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>VBScript Course Price<\/strong><\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Offer Price&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#0C71C3&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; title_text=&#8221;logo_resize_color&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_team_member name=&#8221;Vanitha&#8221; position=&#8221;Author&#8221; image_url=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2024\/09\/Vanitha.png&#8221; _builder_version=&#8221;4.9.7&#8243; header_level=&#8221;h5&#8243; header_font=&#8221;Titillium Web|700|||||||&#8221; body_font=&#8221;Titillium Web||||||||&#8221; body_font_size=&#8221;16&#8243;]The capacity to learn is a gift; the ability to learn is a skill; the willingness to learn is a choice[\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] What is VBScript? VBScript is a [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":93687,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-93669","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-uncategorized"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is VBScript?<\/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:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is VBScript?\" \/>\n<meta property=\"og:description\" content=\"[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] What is VBScript? VBScript is a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudFoundation | Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-18T08:53:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-19T05:18:26+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/VBScript-FI.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"333\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"NAGENDRAG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"NAGENDRAG\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is VBScript?","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:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/","og_locale":"en_US","og_type":"article","og_title":"What is VBScript?","og_description":"[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.7&#8243;][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;#000000&#8243; title_font_size=&#8221;47&#8243; background_color=&#8221;RGBA(0,0,0,0)&#8221; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia||||||||&#8221; text_text_color=&#8221;#000000&#8243; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] What is VBScript? VBScript is a [&hellip;]","og_url":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/","og_site_name":"CloudFoundation | Blog","article_published_time":"2025-03-18T08:53:24+00:00","article_modified_time":"2025-03-19T05:18:26+00:00","og_image":[{"width":500,"height":333,"url":"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/VBScript-FI.jpg","type":"image\/jpeg"}],"author":"NAGENDRAG","twitter_card":"summary_large_image","twitter_misc":{"Written by":"NAGENDRAG"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/","url":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/","name":"What is VBScript?","isPartOf":{"@id":"https:\/\/cloudfoundation.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#primaryimage"},"image":{"@id":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#primaryimage"},"thumbnailUrl":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/VBScript-FI.jpg","datePublished":"2025-03-18T08:53:24+00:00","dateModified":"2025-03-19T05:18:26+00:00","author":{"@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/df6c7eba98f1bb15f2a100a9958266e4"},"breadcrumb":{"@id":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#primaryimage","url":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/VBScript-FI.jpg","contentUrl":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2025\/03\/VBScript-FI.jpg","width":500,"height":333},{"@type":"BreadcrumbList","@id":"https:\/\/cloudfoundation.com\/blog\/what-is-vbscript\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudfoundation.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is VBScript?"}]},{"@type":"WebSite","@id":"https:\/\/cloudfoundation.com\/blog\/#website","url":"https:\/\/cloudfoundation.com\/blog\/","name":"CloudFoundation | Blog","description":"A New way of Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudfoundation.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/df6c7eba98f1bb15f2a100a9958266e4","name":"NAGENDRAG","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09e08ba1102807a876f2c00245d6b955f0a9f027b40c181e9cee0cd2d927f84a?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09e08ba1102807a876f2c00245d6b955f0a9f027b40c181e9cee0cd2d927f84a?s=96&d=wavatar&r=g","caption":"NAGENDRAG"},"url":"https:\/\/cloudfoundation.com\/blog\/author\/nagendrag\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/93669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/comments?post=93669"}],"version-history":[{"count":18,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/93669\/revisions"}],"predecessor-version":[{"id":93710,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/93669\/revisions\/93710"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/media\/93687"}],"wp:attachment":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/media?parent=93669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/categories?post=93669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/tags?post=93669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}