Graphing with Excel = Run-time Error '438'

Post Reply
klepper
Posts: 7
Joined: Sun Mar 25, 2018 5:54 pm

Graphing with Excel = Run-time Error '438'

Post 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 2882 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 2882 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?
Attachments
see.zip
(73.5 KiB) Downloaded 353 times
User avatar
James
Site Admin
Posts: 1109
Joined: Wed Jan 02, 2013 9:06 pm

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

Post 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 ;-)
klepper
Posts: 7
Joined: Sun Mar 25, 2018 5:54 pm

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

Post by klepper »

Cha-chang!!

Thanks! works now, 100%.
Post Reply