Share via

Problems with macros using excel for Mac

Anonymous
2017-02-06T18:01:57+00:00

I  have this excel  which throws up an error caused by the use of the statement in a  macro:  Set objRegEx = CreateObject("VBScript.RegExp")   Is there a Apple package  that can be bought to enable the use of VBScript this way?  Or is there  another recommended way?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2017-02-07T14:37:13+00:00

    Is there a Apple package  that can be bought to enable the use of VBScript this way?  

    Or is there  another recommended way?

    a) No, there is no replacement for this on Mac.

    b) You have to rewrite the code and use only the functions that are available on a Mac.

    In most case you can do the same in VBA with the LIKE operator, and a few lines of code.

    Andreas.

    Was this answer helpful?

    0 comments