Excel VBA Workbook.Open changes Format

[Gindo70]

Hello
i have the following problem:
All Cells of the Wokrbook are in the general format. When i open it manualy it looks like this:

[TABLE="width: 498"]
<tbody>[TR]
[TD="align: right"]349,878235
[/TD]
[TD="align: right"]21,041668[/TD]
[TD="align: right"]36,666668[/TD]
[TD="align: right"]29,895834[/TD]
[TD="align: right"]46,04166[/TD]
[TD="align: right"]39,479168[/TD]
[/TR]
[TR]
[TD="align: right"]350,061096[/TD]
[TD="align: right"]27,867134[/TD]
[TD="align: right"]40,702213[/TD]
[TD="align: right"]28,872379[/TD]
[TD="align: right"]54,324005[/TD]
[TD="align: right"]50,008747
[/TD]
[/TR]
</tbody>[/TABLE]

But when i use Workbooks.open the opened Workbook looks like this (Format of the Cells changed to Number):

[TABLE="width: 498"]
<colgroup><col span="6"></colgroup><tbody>[TR]
[TD="align: right"]349.878.235
[/TD]
[TD="align: right"]21.041.668[/TD]
[TD="align: right"]36.666.668[/TD]
[TD="align: right"]29.895.834[/TD]
[TD="align: right"]46.041.660
[/TD]
[TD="align: right"]39.479.168
[/TD]
[/TR]
[TR]
[TD="align: right"]350.061.096[/TD]
[TD="align: right"]27.867.134[/TD]
[TD="align: right"]40.702.213[/TD]
[TD="align: right"]28.872.379[/TD]
[TD="align: right"]54.324.005[/TD]
[TD="align: right"]50.008.747
[/TD]
[/TR]
</tbody>[/TABLE]

Additional Info:
The Workbook is an Excel 1997-2003 .xls File and i am using Excel 2016

 

[RoryA]

Welcome to the forum.

Try specifying the Local:=True argument for the Workbooks.Open method as well as the file name.

 

[jkpieterse]

Are you sure this is an Excel file and not a txt or csv file? This behaviour is typical for a textfile.
NB: this is a duplicate question:https://www.mrexcel.com/forum/excel-questions/1026136-excel-vba-workbook-open-changes-format.html

 

[Gindo70]

Thanks, that solved the problem!