Page 1 of 1
Excel graphing macro - run-time error 1004
Posted: Wed May 29, 2019 9:43 am
by ebor
Hi,
when I excute the Excel Macro I get error 1004: Method 'Range' of object '_Global' failed
at this line
Range("AM1:AR" & numRows).Select
I am using Office 365 ProPlus Excel and Windows 10. CSV is saved under Android.
Using the "Online Graphing" with the same CSV it is OK.
Best regards
Re: Excel graphing macro - run-time error 1004
Posted: Wed May 29, 2019 9:47 am
by James
Please email me your CSV file and a screenshot of the Excel data created in the GraphingData tab after the fail.
Support@MuseMonitor.com
Re: Excel graphing macro - run-time error 1004
Posted: Wed May 29, 2019 10:06 am
by James
On some European versions of Excel, CSV files (which stands for Comma Separated Values), are set to use a semi colon instead of a comma.
You can change this back to a comma in your system regional settings.
Go to windows settings, choose "Click,Language And Region", then "Change date, time or number formats"
In the dialog that opens, click "Additional Settings" and change the "List separator" to a comma.
Alternatively, if you open the CSV file with notepad, you can add this text to a new row top of the file to let Excel know how to handle the separator:
- ExcelCSVSep.png (25.4 KiB) Viewed 2793 times
Now when you load it, it will know to put each item in it's own column and the Macro will work.
Re: Excel graphing macro - run-time error 1004
Posted: Wed May 29, 2019 10:22 am
by ebor
Thank you! Great app, great support!
Re: Excel graphing macro - run-time error 1004
Posted: Mon Jun 17, 2019 1:06 pm
by Francois
Hi James,
Same issue with error 1004 (I use a French Excel and a muse 2)
I followed your instructions, but both don't work.
May I send you my CSV file ?
Thanks
François
Re: Excel graphing macro - run-time error 1004
Posted: Mon Jun 17, 2019 1:15 pm
by James
Sure. Also EMail me a screenshot of what you see in Excel when you open the file.
Is everything in the first column, or spread out properly?