Hi I am a new user. I am running excel for mac 2011
I have tried just using the tea data provided and when I come to save eta I get an error
Dim compatibilitySetting As Boolean
If CInt(Application.Version) >= 12 Then
compatibilitySetting = ActiveWorkbook.CheckCompatibility
ActiveWorkbook.CheckCompatibility = False
End If
would welcome your input
Hi,
If you change CInt to Val it should resolve the issue, i.e.
If Val(Application.Version) >= 12 Then
If it does not allow you to edit the code, you first need to press the square 'stop' button in the toolbar. I hope that fixes it.
Best,
Frank
Frank thanks for your reply.
I am not very familiar with changing code in macros/ VBA
I will read up on how to do it and have a go.
Tony
Hi Tony,
Which version of StatPlanet are you using? If it's the Shapefile version (StatPlanet Plus), you can download an updated version of the StatPlanet Data Editor here: www.statsilk.com/files/software/StatPlanet_data_editor.xlsm
Best,
Frank