Error when running the macro in excel too

[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

[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.

[olivier]

Ok thank you so much for these informations.I'll try this and tell you if it's ok.

[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 ?

[James]

If you change the regional setting as per above and restart your computer, then when you open the CSV it will load correctly.

[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.

[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".

[olivier]

Yes you're the best, I've got all columns. I just have to wait, that took too many time to create the graph. Perhaps something still going wrong. I'll see !