amarokWPcom
New Member
- Joined
- May 30, 2019
- Messages
- 25
Dear Friends,
I have a problem with a sheet:
I have an extract from SAP made by my VBA.
In the extract all columns are fine expect one column which is for quantities.
If the vba opens the file, this column is already broken (please find attached example file). Only some cells are still correct as you can see in the example if you compare it to the manually opened file.
The far right columns are how it has to be. All cells have to be numbers with the correct separator.
At the moment I have to break my code in pieces... open the file manully - changing the columns to format "numbers" - and proceed.
But this cannot be the way????
I guess the problem is because of the country code but I am not sure.
As you can see in the example I could find an algorythm which could correct me the column if opend by the code for surebut I am sure there is a even more easier way.
All my systems are in english, but em I am from Hamburg
To opening in VBA I use the comand:
Workbooks.Open STR_EXTRACT_PATH & "ZPNBCEXTRACT.xls"
Ups.... How can I attach the example file here???
I have a problem with a sheet:
I have an extract from SAP made by my VBA.
In the extract all columns are fine expect one column which is for quantities.
If the vba opens the file, this column is already broken (please find attached example file). Only some cells are still correct as you can see in the example if you compare it to the manually opened file.
The far right columns are how it has to be. All cells have to be numbers with the correct separator.
At the moment I have to break my code in pieces... open the file manully - changing the columns to format "numbers" - and proceed.
But this cannot be the way????
I guess the problem is because of the country code but I am not sure.
As you can see in the example I could find an algorythm which could correct me the column if opend by the code for surebut I am sure there is a even more easier way.
All my systems are in english, but em I am from Hamburg
To opening in VBA I use the comand:
Workbooks.Open STR_EXTRACT_PATH & "ZPNBCEXTRACT.xls"
Ups.... How can I attach the example file here???