Ignoring an expected compile error

[ByteMarks]

HI,
I have an addin which is distributed to a number of users. All users have 32bit office but some of them use Office 2007 and others use Office 365.

My addin contains an number of UDFs and I use the application.macrooptions method to add descriptions of the function and arguments.

The problem is that Office 2007 doesn't support the arguments and gives a compile error.
I don't want to remove these as they work fine in O365, so is there anyway I can ignore that error?

I've already tried checking the application version and On Error Resume Next, but this is probably too late to catch the compilation.

[ranman256]

can you alter the code and add:
on error resume next

if not try the excel command to turn off error msgs:
Application.DisplayAlerts = false

[Kaper]

I think the conditional compilation could help.
Use VBA6 for Excel 2007 version

see https://docs.microsoft.com/pl-pl/off...iler-constants

[ByteMarks]

Hi All,

I'm still having this issue. I've tried Resume Next and checking the version but the error occurs before anything is executed.

I have quite a few UDFs which are proceesed by this routine which is called from the Addin_Install event.
In later version of Excel it's fine, but in earlier versions "ArgumentDescriptions" is not supported and produces a compile error during the install.
There isn't any loss of functionality other than the absence of argument descriptions, so I'd like be able to suppress/ignore the compile error.

Please Login or Register  to view this content.

[ByteMarks]

I solved this. It was just a case of having a conditional compliation:

Please Login or Register  to view this content.

[Kaper]

Seems my advice from #3, 3 months ago was right. The code above is (I think) equivalent to:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[ByteMarks]

Yes it was, thank you!
Unfortunately I didn't check back here until recently - could have saved a lot of time if I had.