![]() Trans_std_ver = "Transaction Type 1 :" & Me.TextBox86.Value & " Version Used: " & Me.TextBox87.Value ![]() EDI/EC profiles checkboxes conversion to string ![]() Set regex = CreateObject("VBScript.RegExp") **Set regex = CreateObject("VBScript.RegExp")** // THIS LINE //ĬOMPLETE CODE : Dim edi_ec, edi_doc, method_implement, van As String The error causing code: Dim edi_ec, edi_doc, method_implement, van As String ![]() Replaced Set regex = CreateObject("VBScript.RegExp") with Dim regex As New VBScript.RegExp I followed this link Excel VBA alteration for MAC pkg file and add it to the VBA library but this showed error like "This file is not supported". So I followed this link which asked me to download. But on going through various pages, I found that Microsoft vbscript regular expressions object library doesn't exists for Mac. " Run_Time error '429': ActiveX Component Cant't Create Objectġ.Adding Reference of Regular Expression since my code uses regex. The main problem is that I have an Excel VBA Userform that throws error of the following kind for Mac user : I know this question have been asked several time in different form but I have tried several ways to solve this issue but not getting any that could help me.
0 Comments
Leave a Reply. |