Page 1 of 1
Error when running the macro in excel too
Posted: Thu Apr 25, 2019 5:58 am
by olivier
Hello, as the topic of Andrei in sept, I've got the same problem.
The macro bug when I start it and I've got the same message.
I had tried too change False to True on line 16 but I still got the bug.
I've got excel 365 download 3 days ago.
Could someone help me?
Thank's
Re: Error when running the macro in excel too
Posted: Thu Apr 25, 2019 9:00 am
by James
When you open the CSV does it correctly load each value into a separate column, or is everything in the first column?
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.
Re: Error when running the macro in excel too
Posted: Thu Apr 25, 2019 9:28 am
by olivier
Ok thank you so much for these informations.I'll try this and tell you if it's ok.
Re: Error when running the macro in excel too
Posted: Thu Apr 25, 2019 9:43 am
by olivier
ok sorry, the translator told me wrong!
It's comma separator I've got on excel.
But I didn't saw that all values are in the first column.... I need to change everything column by column or is there a quickly method ?
Re: Error when running the macro in excel too
Posted: Thu Apr 25, 2019 9:44 am
by James
If you change the regional setting as per above and restart your computer, then when you open the CSV it will load correctly.
Re: Error when running the macro in excel too
Posted: Thu Apr 25, 2019 10:45 am
by olivier
Nothing change.
I'd tried with Great Britain and USA config.
I still have all values in the first column. I had tried with 3 documents and it's all the same thing.
Re: Error when running the macro in excel too
Posted: Thu Apr 25, 2019 10:46 am
by James
All you need to change is the list separator, nothing else.
If you want to do it manually, you can click the button "Data -> Text to columns".
Re: Error when running the macro in excel too
Posted: Thu Apr 25, 2019 11:39 am
by olivier