Page 1 of 1

Graphing with Excel = Run-time Error '438'

Posted: Sun Mar 25, 2018 6:16 pm
by klepper
Followed the guide, to the letter: http://www.musemonitor.com/Macro.php

Doubled checked it all, but when I run it, I get this error:
2018-03-25 16_04_18-Microsoft Excel non-commercial use - museMonitor_2018-03-06--22-10-13_2062521064.jpg
2018-03-25 16_04_18-Microsoft Excel non-commercial use - museMonitor_2018-03-06--22-10-13_2062521064.jpg (16.75 KiB) Viewed 2848 times
I hit debug and it highlights:

ActiveSheet.Shapes.AddChart2(227, xlLine).Select

like so:
2018-03-25 16_13_29-Microsoft Visual Basic for Applications - PERSONAL.XLSB [break].jpg
2018-03-25 16_13_29-Microsoft Visual Basic for Applications - PERSONAL.XLSB [break].jpg (129.98 KiB) Viewed 2848 times
Any thoughts?

Attached "see.zip" is the museMonitor_2018-03-24--06-27-52_2000831781.csv

I did mess around with the settings in the android app, maybe I selected or changed something that's messing it up?

Re: Graphing with Excel = Run-time Error '438'

Posted: Sun Mar 25, 2018 6:47 pm
by James
You have an older version of Excel. Change "OldExcel" to true at the top and it'll work, but look less pretty when it's done ;-)

Re: Graphing with Excel = Run-time Error '438'

Posted: Mon Mar 26, 2018 8:11 am
by klepper
Cha-chang!!

Thanks! works now, 100%.