VBA CODE for JAVASCRIPT CODE

[ashish1110]

Request to provide VBA code for below javascript code


htmlStr = htmlStr.replace(/[\n\r]+/g, '');
htmlStr = htmlStr.replace(/\"/g, "\"\"");
htmlStr = "\"" + htmlStr + "\"";

 

[bertie]

Hi and welcome to the forum.

I don't know JavaScript, but the first two lines of your code looks like, "Find and Replace". Here is the vba REPLACE function; you will need to edit the highlighted parts.

   htmlStr = Replace(Expression:=htmlStr, _
                     Find:=[COLOR=#ff0000]FindString[/COLOR], _
                     Replace:=[COLOR=#ff0000]ReplacementString[/COLOR], _
                     Compare:=vbTextCompare)

NB: we can omit specifically referencing the REPLACE function's arguments. The above can be written as:

htmlStr = Replace(htmlStr, [COLOR=#ff0000]FindString[/COLOR], [COLOR=#ff0000]ReplacementString[/COLOR], vbTextCompare)

The third line looks like concatenating a backslash onto the htmlStr variable. In VBA the ampersand is the concatenation character.:

   htmlStr = "\" & htmlStr & "\"

Hope this helps,
Bertie