Recorded macro does other than while recording

[HvLbeheer]

I've got a file Afrekeningen.xlsm. I'v got a file Afrekening 15-06-2017.csv.
When I record a macro to import the .csv to the .xlsm I get currency results in column C and cells B4 to B9.
When i play the macro, the results are only digits in column C and no results in cells B4 to B9.

The macro is recorded within the .xlsm file. Both files are includes in this post.
Can somebody help me out to make this work?

[Tsjallie]

Hi,
welcome to this formum.

The problem with the numbers not showing in column B is with the decimal separator.
The data comes with a dot as separator and then the macro replaces these dots by commas. Excel isn't handling that properly.

Add these two properties to the connection
.TextFileDecimalSeparator = "."
.TextFileThousandsSeparator = ","
and remove the lines replacing of dots by commas.

This will give the macro as below:

Please Login or Register  to view this content.

[HvLbeheer]

Dear Tsjallie,

Thank you so much for solving this problem.
I'm never to old to learn and I'm grateful there is always someone to help.

Kind regards,
Frans Knuvers

[Tsjallie]

Hi Frans,
glad I could help.
If this solved your problem pls mark the thread SOLVED (see Thread Tools in the menu above).

BTW, I noticed that this macro will create a connections each time you run it.
Not sure if that's what you intend.