Run code dependent on Excel version

[Ludwig]

I have a need to turn off ThisWorkbook.AutoSaveOn if it is on. Easily done, however if the user opens the workbook using 2013 or earlier, the VBAProject fails to compile. Perfectly understandable.

My question is ... is there a way to code the test in the VBA but "ignored" if not valid?

For example, being able to say (I know it won't work as shown) and have it compile and run on Excel 2013 & even earlier versions ..

If Val(Application.Version) > 15 then 
     if ThisWorkbook.AutoSaveOn then ThisWorkbook.AutoSaveOn = False"
end if

Is there a way to run a command in an equivalent manner to formula expression "Indirect("string")"?

Thanks for your help.

 

[jkpieterse]

If the default compile settings are in place then you can simply move the offending code to another sub and branch there if needed. VBA won't try to compile that sub as long as it isn't touched:

'Previous code
If Val(Application.Version) > 15 then 
    CheckAutosave
End If
'More code...

Sub CheckAutosave()
     if ThisWorkbook.AutoSaveOn then ThisWorkbook.AutoSaveOn = False
end Sub

 

[Ludwig]

So simple!! Hadn't thought that VBA is compiled 'when used/called'. Many thanks, will do that now!