{"id":54168,"date":"2023-08-19T17:56:49","date_gmt":"2023-08-19T16:56:49","guid":{"rendered":"https:\/\/ekiwi-blog.de\/54168\/vba-replace-string-text-replace-function\/"},"modified":"2023-08-19T18:16:10","modified_gmt":"2023-08-19T17:16:10","slug":"vba-replace-string-text-replace-function","status":"publish","type":"post","link":"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/","title":{"rendered":"VBA Replace String, Text (Replace Function)"},"content":{"rendered":"<p><abbr title=\"Visual Basis for Application\">VBA<\/abbr> is wonderful for automating various things in the Microsoft Office world and creating some nice tools for working more effectively.<\/p>\n<p>A typical case that occurs not only in VBA, but also in many other programming languages, is the <strong>replacement of a text by another text<\/strong>. The replacement can be complete, or only a <strong>substring<\/strong> (partial text) in the original string is to be replaced. For example, this could be a file extension in a file name that is to be substituted.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of content<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/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:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Replace_function_parameter_explained\" >Replace function parameter explained<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Expression\" >Expression<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Find\" >Find<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Replace\" >Replace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#start\" >start<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Count\" >Count<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Compare\" >Compare<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#-1_vbUseCompareOption\" >[-1] vbUseCompareOption<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#0_vbBinaryCompare\" >[0] vbBinaryCompare<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#1_vbTextCompare\" >[1] vbTextCompare<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#2_vbDatabaseCompare\" >[2] vbDatabaseCompare<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Return_value\" >Return value<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Application_examples_Replace_function_in_VBA\" >Application examples Replace function in VBA<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Simple_example_without_optional_parameters\" >Simple example without optional parameters<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Replace_only_certain_number_in_string\" >Replace only certain number in string<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Search_string_from_certain_position\" >Search string from certain position<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/ekiwi-blog.de\/en\/54168\/vba-replace-string-text-replace-function\/#Replace_last_occurrence_of_a_string\" >Replace last occurrence of a string<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Replace_function_parameter_explained\"><\/span>Replace function parameter explained<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>For this purpose, VBA has the <em>Replace<\/em> function, which has the following parameters and return values.<\/p>\n<figure id=\"attachment_7677\" aria-describedby=\"caption-attachment-7677\" style=\"width: 960px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7677\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2020\/11\/vba-replace-parameters.png\" alt=\"Screenshot VBA-Editor Replace Funtkion mit Parameterhinweisen\" width=\"960\" height=\"38\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2020\/11\/vba-replace-parameters.png 960w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2020\/11\/vba-replace-parameters-300x12.png 300w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2020\/11\/vba-replace-parameters-768x30.png 768w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><figcaption id=\"caption-attachment-7677\" class=\"wp-caption-text\">Parameters of the Replace function<\/figcaption><\/figure>\n<div>\n<h3 style=\"float: none; width: 50%;\"><span class=\"ez-toc-section\" id=\"Expression\"><\/span>Expression<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div>This is the original string\/text which is to be searched for another string.<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Find\"><\/span>Find<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is the text or text fragment (substring) to be found in the original text.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Replace\"><\/span>Replace<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is the text with which the searched text is to be replaced.<br \/>\n\n<div class=\"aawp\">\n\n            \n            \n<div class=\"aawp-product aawp-product--horizontal aawp-product--bestseller aawp-product--ribbon\"  data-aawp-product-asin=\"3367105732\" data-aawp-product-id=\"109254\" data-aawp-tracking-id=\"ekiwide0b-21\" data-aawp-product-title=\"VBA mit Excel  Das umfassende Handbuch f\u00fcr Einsteiger und fortgeschrittene Anwender Aktuell zu Excel 2024 und Microsoft 365 \u2013 Ausgabe 2025\">\n\n    <span class=\"aawp-product__ribbon aawp-product__ribbon--bestseller\">Bestseller No. 1<\/span>\n    <div class=\"aawp-product__thumb\">\n        <a class=\"aawp-product__image-link\"\n           href=\"https:\/\/www.amazon.de\/dp\/3367105732?tag=ekiwide0b-21&linkCode=ogi&th=1&psc=1&keywords=book%20vba\" title=\"VBA mit Excel: Das umfassende Handbuch f\u00fcr...\" rel=\"nofollow noopener sponsored\" target=\"_blank\">\n            <img decoding=\"async\" class=\"aawp-product__image\" src=\"https:\/\/m.media-amazon.com\/images\/I\/51EVPKCMSSL._SL160_.jpg\" alt=\"VBA mit Excel: Das umfassende Handbuch f\u00fcr...\"  \/>\n        <\/a>\n\n            <\/div>\n\n    <div class=\"aawp-product__content\">\n        <a class=\"aawp-product__title\" href=\"https:\/\/www.amazon.de\/dp\/3367105732?tag=ekiwide0b-21&linkCode=ogi&th=1&psc=1&keywords=book%20vba\" title=\"VBA mit Excel: Das umfassende Handbuch f\u00fcr...\" rel=\"nofollow noopener sponsored\" target=\"_blank\">\n            VBA mit Excel: Das umfassende Handbuch f\u00fcr...        <\/a>\n        <div class=\"aawp-product__description\">\n                    <\/div>\n    <\/div>\n\n    <div class=\"aawp-product__footer\">\n\n        <div class=\"aawp-product__pricing\">\n            \n                            <span class=\"aawp-product__price aawp-product__price--current\">49,90 EUR<\/span>\n            \n            <a href=\"https:\/\/www.amazon.de\/gp\/prime\/?tag=ekiwide0b-21\" title=\"Amazon Prime\" rel=\"nofollow noopener sponsored\" target=\"_blank\" class=\"aawp-check-prime\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/plugins\/aawp\/assets\/img\/icon-check-prime.svg\" height=\"16\" width=\"55\" alt=\"Amazon Prime\" \/><\/a>        <\/div>\n\n                <a class=\"aawp-button aawp-button--buy aawp-button--icon aawp-button--icon-black\" href=\"https:\/\/www.amazon.de\/dp\/3367105732?tag=ekiwide0b-21&#038;linkCode=ogi&#038;th=1&#038;psc=1&#038;keywords=book%20vba\" title=\"Buy on Amazon\" target=\"_blank\" rel=\"nofollow noopener sponsored\">Buy on Amazon<\/a>\n            <\/div>\n\n<\/div>\n\n    \n<\/div>\n<\/p>\n<h3><span class=\"ez-toc-section\" id=\"start\"><\/span>start<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This is an optional parameter. Here, you can specify at which point\/position in the original text the search and replace should start. It is a numerical value. The first letter starts at 1. This is a bit unusual, as in other programming languages it always starts at zero. The default value is 1.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Count\"><\/span>Count<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Also, an optional parameter. If the substring you are looking for occurs several times in the original text, you can specify here how often the substring should be replaced. This is practical if you only want to replace the first occurrence of a string.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Compare\"><\/span>Compare<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This numerical parameter, which determines the comparison method, is rarely needed. The default value is sufficient here. Otherwise, there is<\/p>\n<h4><span class=\"ez-toc-section\" id=\"-1_vbUseCompareOption\"><\/span>[-1] vbUseCompareOption<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>When using this parameter, an <a href=\"https:\/\/learn.microsoft.com\/es-es\/office\/vba\/language\/reference\/user-interface-help\/option-compare-statement\">option-compare statement<\/a> must precede the respective procedure.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"0_vbBinaryCompare\"><\/span>[0] vbBinaryCompare<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>It compares the binary representation of searched string and searched string.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"1_vbTextCompare\"><\/span><span data-ttu-id=\"00441-142\">[1] vbTextCompare<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>A text comparison is made between the searched string and the searched string.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"2_vbDatabaseCompare\"><\/span>[2] vbDatabaseCompare<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Used only in Microsoft Access for comparisons within databases.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Return_value\"><\/span>Return value<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/div>\n<p>The <strong>return value<\/strong> is the new string with the replaced parameters.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Application_examples_Replace_function_in_VBA\"><\/span>Application examples Replace function in VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Simple_example_without_optional_parameters\"><\/span>Simple example without optional parameters<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Here, all substrings found are substituted with the text to be replaced.<\/p>\n<pre><code><span style=\"color: #3366ff;\">Private Sub<\/span> ReplaceExample1()\r\n  <span style=\"color: #3366ff;\">Dim<\/span> strOriginal <span style=\"color: #3366ff;\">As String<\/span>.\r\n  <span style=\"color: #3366ff;\">Dim<\/span> strSearch <span style=\"color: #3366ff;\">As String<\/span>\r\n  <span style=\"color: #3366ff;\">Dim<\/span> strReplace <span style=\"color: #3366ff;\">As String<\/span>.\r\n  <span style=\"color: #3366ff;\">Dim<\/span> strNew <span style=\"color: #3366ff;\">As String<\/span>\r\n\r\n  strOrignal = \"My grandma rides a motorbike in the chicken coop!\"\r\n  strSearch = \"Motorcycle\"\r\n  strReplace = \"Tricycle\"\r\n\r\n  strNew = Replace(strOrignal, strSearch, strReplace)\r\n  <span style=\"color: #339966;\">'Output to direct window<\/span>\r\n  <span style=\"color: #3366ff;\">Debug.Print<\/span> strNew\r\n<span style=\"color: #3366ff;\">End Sub<\/span><\/code><\/pre>\n<pre><strong>Output\/Result:<\/strong> <em>My grandma rides a <u>tricycle<\/u> in the chicken coop!<\/em><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Replace_only_certain_number_in_string\"><\/span>Replace only certain number in string<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In this example, only one occurrence of the searched text is replaced because the optional parameter <em>Count<\/em> has been defined.<\/p>\n<pre><code><span style=\"color: #3366ff;\">Private Sub<\/span> ReplaceExample2()\r\n<span style=\"color: #3366ff;\">Dim<\/span> strOriginal <span style=\"color: #3366ff;\">As String<\/span>.\r\n<span style=\"color: #3366ff;\">Dim<\/span> strSearch <span style=\"color: #3366ff;\">As String<\/span>\r\n<span style=\"color: #3366ff;\">Dim<\/span> strReplace <span style=\"color: #3366ff;\">As String<\/span>.\r\n<span style=\"color: #3366ff;\">Dim<\/span> strNew <span style=\"color: #3366ff;\">As String<\/span>\r\n\r\nstrOrignal = \"If you give opium to Opi, opium will kill Opi!\"\r\nstrSearch = \"Opi\"\r\nstrReplace = \"Omi\"\r\n\r\nstrNew = Replace(strOrignal, strSearch, strReplace, Count:=1)\r\n\r\n<span style=\"color: #3366ff;\">Debug.Print<\/span> strNew\r\n<span style=\"color: #3366ff;\">End Sub<\/span><\/code><\/pre>\n<pre><strong>Output\/Result:<\/strong> <em>Give <u>Omi<\/u> opium, opium kills opi!<\/em><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Search_string_from_certain_position\"><\/span>Search string from certain position<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This example shows how a string is <a title=\"Excel search from bottom to top (backwards search)\" href=\"https:\/\/ekiwi-blog.de\/en\/25078\/excel-find-search-from-bottom-to-top-backwards-search\/\">searched from<\/a> a certain positione (20) and the occurrences of the searched string are replaced. Only the string from the start position is then returned.<\/p>\n<pre><code><span style=\"color: #3366ff;\">Private Sub<\/span> ReplaceExample3()\r\n<span style=\"color: #3366ff;\">Dim<\/span> strOriginal <span style=\"color: #3366ff;\">As String<\/span>.\r\n<span style=\"color: #3366ff;\">Dim<\/span> strSearch <span style=\"color: #3366ff;\">As String<\/span>.\r\nDim strReplace <span style=\"color: #3366ff;\">As String<\/span>\r\n<span style=\"color: #3366ff;\">Dim<\/span> strNew <span style=\"color: #3366ff;\">As String<\/span>\r\n\r\nstrOrignal = \"If you give opium to opi, opium will kill opi!\"\r\nstrSearch = \"Opium\"\r\nstrReplace = \"Omi\"\r\n\r\nstrNew = Replace(strOrignal, strSearch, strReplace, Start:=20)\r\n\r\n<span style=\"color: #3366ff;\">Debug.Print<\/span> strNew\r\n<span style=\"color: #3366ff;\">End Sub<\/span><\/code><\/pre>\n<pre><strong>Output\/Result:<\/strong> <em>kills grandma grandpa!<\/em><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Replace_last_occurrence_of_a_string\"><\/span>Replace last occurrence of a string<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The optional parameters <em>Count<\/em> and <em>Start<\/em> are not particularly good for replacing the last occurrence of a character or string, as you never know how long the orignal string is. To replace the last occurrence of a string in a string, one must use the <em>strReverse<\/em> function. This simply reverses the string as if you were reading it backwards. Our <em>&#8220;Opi&#8221;<\/em> then becomes <em>&#8220;ipO&#8221;<\/em>. This is how you can make a substitution from the back.<\/p>\n<pre><code><span style=\"color: #3366ff;\">Private Sub<\/span> ReplaceExample4()\r\n<span style=\"color: #3366ff;\">Dim<\/span> strOriginal <span style=\"color: #3366ff;\">As String<\/span>.\r\n<span style=\"color: #3366ff;\">Dim<\/span> strSearch <span style=\"color: #3366ff;\">As String<\/span>.\r\n<span style=\"color: #3366ff;\">Dim<\/span> strReplace <span style=\"color: #3366ff;\">As String<\/span>.\r\n<span style=\"color: #3366ff;\">Dim<\/span> strNew <span style=\"color: #3366ff;\">As String<\/span>\r\n\r\nstrOrignal = \"If you give opium to Opi, opium will kill Opi!\"\r\nstrSearch = \"Opi\"\r\nstrReplace = \"Omi\"\r\n\r\nstrNew = StrReverse(Replace(StrReverse(strOrignal), StrReverse(strSearch), StrReverse(strReplace), Count:=1))\r\n\r\n<span style=\"color: #3366ff;\">Debug.Print<\/span> strNew\r\n<span style=\"colour: #3366ff;\">End Sub<\/span><\/code><\/pre>\n<pre><strong>Output\/Result:<\/strong> <em>Give grandpa opium, opium kills grandma!<\/em><\/pre>\n\n<div class=\"aawp\">\n\n            \n            \n<div class=\"aawp-product aawp-product--horizontal aawp-product--bestseller aawp-product--ribbon\"  data-aawp-product-asin=\"3367105732\" data-aawp-product-id=\"109254\" data-aawp-tracking-id=\"ekiwide0b-21\" data-aawp-product-title=\"VBA mit Excel  Das umfassende Handbuch f\u00fcr Einsteiger und fortgeschrittene Anwender Aktuell zu Excel 2024 und Microsoft 365 \u2013 Ausgabe 2025\">\n\n    <span class=\"aawp-product__ribbon aawp-product__ribbon--bestseller\">Bestseller No. 1<\/span>\n    <div class=\"aawp-product__thumb\">\n        <a class=\"aawp-product__image-link\"\n           href=\"https:\/\/www.amazon.de\/dp\/3367105732?tag=ekiwide0b-21&linkCode=ogi&th=1&psc=1&keywords=book%20vba\" title=\"VBA mit Excel: Das umfassende Handbuch f\u00fcr...\" rel=\"nofollow noopener sponsored\" target=\"_blank\">\n            <img decoding=\"async\" class=\"aawp-product__image\" src=\"https:\/\/m.media-amazon.com\/images\/I\/51EVPKCMSSL._SL160_.jpg\" alt=\"VBA mit Excel: Das umfassende Handbuch f\u00fcr...\"  \/>\n        <\/a>\n\n            <\/div>\n\n    <div class=\"aawp-product__content\">\n        <a class=\"aawp-product__title\" href=\"https:\/\/www.amazon.de\/dp\/3367105732?tag=ekiwide0b-21&linkCode=ogi&th=1&psc=1&keywords=book%20vba\" title=\"VBA mit Excel: Das umfassende Handbuch f\u00fcr...\" rel=\"nofollow noopener sponsored\" target=\"_blank\">\n            VBA mit Excel: Das umfassende Handbuch f\u00fcr...        <\/a>\n        <div class=\"aawp-product__description\">\n                    <\/div>\n    <\/div>\n\n    <div class=\"aawp-product__footer\">\n\n        <div class=\"aawp-product__pricing\">\n            \n                            <span class=\"aawp-product__price aawp-product__price--current\">49,90 EUR<\/span>\n            \n            <a href=\"https:\/\/www.amazon.de\/gp\/prime\/?tag=ekiwide0b-21\" title=\"Amazon Prime\" rel=\"nofollow noopener sponsored\" target=\"_blank\" class=\"aawp-check-prime\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/plugins\/aawp\/assets\/img\/icon-check-prime.svg\" height=\"16\" width=\"55\" alt=\"Amazon Prime\" \/><\/a>        <\/div>\n\n                <a class=\"aawp-button aawp-button--buy aawp-button--icon aawp-button--icon-black\" href=\"https:\/\/www.amazon.de\/dp\/3367105732?tag=ekiwide0b-21&#038;linkCode=ogi&#038;th=1&#038;psc=1&#038;keywords=book%20vba\" title=\"Buy on Amazon\" target=\"_blank\" rel=\"nofollow noopener sponsored\">Buy on Amazon<\/a>\n            <\/div>\n\n<\/div>\n\n            \n            \n<div class=\"aawp-product aawp-product--horizontal aawp-product--bestseller aawp-product--ribbon\"  data-aawp-product-asin=\"3832803033\" data-aawp-product-id=\"108725\" data-aawp-tracking-id=\"ekiwide0b-21\" data-aawp-product-title=\"VBA mit Excel - Der leichte Einstieg  Vom ersten Makro zur eigenen Eingabemaske - F\u00fcr Excel 2010 bis 2021 365  Die anschauliche Anleitung f\u00fcr .. Eingabemaske - F\u00fcr Excel 2010 bis 2019\">\n\n    <span class=\"aawp-product__ribbon aawp-product__ribbon--bestseller\">Bestseller No. 2<\/span>\n    <div class=\"aawp-product__thumb\">\n        <a class=\"aawp-product__image-link\"\n           href=\"https:\/\/www.amazon.de\/dp\/3832803033?tag=ekiwide0b-21&linkCode=ogi&th=1&psc=1&keywords=book%20vba\" title=\"VBA mit Excel - Der leichte Einstieg: Vom ersten...\" rel=\"nofollow noopener sponsored\" target=\"_blank\">\n            <img decoding=\"async\" class=\"aawp-product__image\" src=\"https:\/\/m.media-amazon.com\/images\/I\/51Ssb4JGplL._SL160_.jpg\" alt=\"VBA mit Excel - Der leichte Einstieg: Vom ersten...\"  \/>\n        <\/a>\n\n            <\/div>\n\n    <div class=\"aawp-product__content\">\n        <a class=\"aawp-product__title\" href=\"https:\/\/www.amazon.de\/dp\/3832803033?tag=ekiwide0b-21&linkCode=ogi&th=1&psc=1&keywords=book%20vba\" title=\"VBA mit Excel - Der leichte Einstieg: Vom ersten...\" rel=\"nofollow noopener sponsored\" target=\"_blank\">\n            VBA mit Excel - Der leichte Einstieg: Vom ersten...        <\/a>\n        <div class=\"aawp-product__description\">\n                    <\/div>\n    <\/div>\n\n    <div class=\"aawp-product__footer\">\n\n        <div class=\"aawp-product__pricing\">\n            \n                            <span class=\"aawp-product__price aawp-product__price--current\">19,90 EUR<\/span>\n            \n            <a href=\"https:\/\/www.amazon.de\/gp\/prime\/?tag=ekiwide0b-21\" title=\"Amazon Prime\" rel=\"nofollow noopener sponsored\" target=\"_blank\" class=\"aawp-check-prime\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/plugins\/aawp\/assets\/img\/icon-check-prime.svg\" height=\"16\" width=\"55\" alt=\"Amazon Prime\" \/><\/a>        <\/div>\n\n                <a class=\"aawp-button aawp-button--buy aawp-button--icon aawp-button--icon-black\" href=\"https:\/\/www.amazon.de\/dp\/3832803033?tag=ekiwide0b-21&#038;linkCode=ogi&#038;th=1&#038;psc=1&#038;keywords=book%20vba\" title=\"Buy on Amazon\" target=\"_blank\" rel=\"nofollow noopener sponsored\">Buy on Amazon<\/a>\n            <\/div>\n\n<\/div>\n\n    \n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>VBA is wonderful for automating various things in the Microsoft Office world and creating some nice tools for working more<\/p>\n","protected":false},"author":2,"featured_media":6532,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1555],"tags":[1701,1855,1857,2168,1569,1861,1710],"class_list":["post-54168","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-en","tag-access-en","tag-excel-en-2","tag-microsoft-en-2","tag-office-en","tag-outlook-en","tag-vba-en-2","tag-word-en"],"_links":{"self":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/54168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/comments?post=54168"}],"version-history":[{"count":0,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/54168\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media\/6532"}],"wp:attachment":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media?parent=54168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/categories?post=54168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/tags?post=54168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}