Excel 2010 vs Excel 2019 Error

[Av8tordude]

I ran into an code error with my 2010 excel. Apparently Excel 2019 has support for some code that Excel 2010 does not support. Case in point…The below line of code causes an error in Excel 2010 but not in Excel 2019. How can I fix this?

.PivotFields("Exit Date").AutoGroup

With Pvt

.PivotFields("Exit Date").Orientation = xlRowField

.PivotFields("Exit Date").AutoGroup

.AddDataField Pvt.PivotFields("Profit/Loss ($)"), "Sum of Profit/Loss ($)", xlSum

.PivotFields("Sum of Profit/Loss ($)").NumberFormat = "$#,##0.00;[Red]$-#,##0.00"

End With

 

[joeu2004]

@Av8tordude .... We cannot expect "forward compatibility" in old versions. But we can "expect" (hope for) "backward compatibility" in new versions.

My approach is to implement VBA code in the oldest version of Excel that I want my VBA code to work in. The hope is: it will also work in any future version of Excel.

That said, MSFT is renowned for breaking backward compatibility. Case in point: the introduction of "@" syntax for formulas in recent versions of Excel.

If necessary, you might try to determine the Excel version programmatically, and use conditional compilation (#IF) to implement multiple versions of VBA code (sigh).

The following suggests one method: [SOLVED] How to identify my version of VBA .

I have not vetted the information.

I think Application.Version provides a more direct method. But I have not looked for a webpage that describes all of its values, especially a list that is up-to-date.

 

[Av8tordude]

Thanks for the insight Joe