Compile error in hidden module

[RAJESH1960]

Hello JohnnyL
The application Match Portal is running perfect in every way. Today I visited a new office and tested to run Match Portal application. But I ran into this error for the first time. What could be the reason and how do I rectify it to make it compatible to run in all versions of excel.?
Compile error in hidden module Match Portal
This error commonly occurs when code is incompatible with the version, platform or architecture of this application.

 

[Fluff]

I only scanned the code quickly, so have no idea if anything else needs changing. Best way to find out is to try it.

 

[RAJESH1960]

I only scanned the code quickly, so have no idea if anything else needs changing. Best way to find out is to try it.

Ok. Thanks Fluff. Will check it out tomorrow and revert back.

 

[johnnyL]

I can't confirm that 'add2' causes an issue with 2007 32bit or 2013 32bit.

I can confirm that:

        .Columns("G:I").Replace What:="0", Replacement:="", LookAt:=xlWhole, _
            SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula

does cause an issue in 2007 32bit & 2013 32bit, specifically the ', FormulaVersion:=xlReplaceFormula' portion.

 

[Fluff]

I can't confirm that 'add2'

I can, Add2 only appeared with xl2016

 

[johnnyL]

I can, Add2 only appeared with xl2016

Thank you @Fluff.

There you go @RAJESH1960 with Fluff's suggestion and the line of code I pointed out, you should be good to go.

 

[6StringJazzer]

You will need to change the Add2 to Add on these rows & anywhere else they occur

I can see where this could cause a runtime issue but could it cause a compile error as reported in post #1?

 

[RAJESH1960]

and the line of code I pointed out

what and how do I edit that line.?

 

[johnnyL]

what and how do I edit that line.?

Comment out the portion I mentioned or delete it.

Make it be:

        .Columns("G:I").Replace What:="0", Replacement:="", LookAt:=xlWhole, _
            SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False                                                                                     ' , FormulaVersion:=xlReplaceFormula

Or just:

        .Columns("G:I").Replace What:="0", Replacement:="", LookAt:=xlWhole, _
            SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False

 

[Fluff]

I can see where this could cause a runtime issue but could it cause a compile error as reported in post #1?

I have no idea & as I only have 365 I have no way to test it.
Also I have never encountered the "Compile error in hidden module" error.

 

[RAJESH1960]

Comment out the portion I mentioned or delete it.

Make it be:

        .Columns("G:I").Replace What:="0", Replacement:="", LookAt:=xlWhole, _
            SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False                                                                                     ' , FormulaVersion:=xlReplaceFormula

Or just:

        .Columns("G:I").Replace What:="0", Replacement:="", LookAt:=xlWhole, _
            SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False

.Columns("G:I").Replace What:="0", Replacement:="", LookAt:=xlWhole, _
            SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False
            'FormulaVersion:=xlReplaceFormula

Like this OK.?