Importing text with VBA and problems with language settings

[CsJHUN]

Hi guys,

I'm importing text data separated with ";" . The numbers decimal sign is "," in the CSV, so 14,000 = 14
I have 2 file if im import (drag and drop) into first its works like charm, if i drop into other its give wrong numbers 14,000 = 14000.
Does anyone know any solution?

The first file is ~20MB, i recreated it totally the same "layout", same sheets, similar macro, so on but its 400kb. I didnt found why is the old one is so big.
The first one is the old one, not i made, give correct value for numbers. The 2nd one is a new one, i (re)made it, not giving correct values.
The macro recorder give the same results importing(dragging) to each file. I guess the excel temporary change the language settings while the old file running, is this possible?

Thx for ideas

 

[CsJHUN]

I cannot edit.... :S
Is there a way to change the windows/excel langauge settings temporary with VBA?

 

[CsJHUN]

I found the solution of my problem:
on the workbook properties macro:

Private Sub Workbook_Open()    Application.UseSystemSeparators = False
    Application.DecimalSeparator = ","
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.UseSystemSeparators = True
End Sub