Different value before and after the Macro

[rafa.jsilva]

Hi, Everyone!

I created a macro that exports data from SAP in .xls format but my problem is when opening the .xls file where the column "H" the volars return modified.
Example: cell H23 = 1.833 (before opening macro) -> H23 = 1.833 (after opening macro)
In this case I cannot use sumif formula correctly.

Could Somebody help me?

Regards,
Rafael

EXTRATOR_TESTE.xlsm
123.xls

[vba_php]

I created a macro that exports data from SAP in .xls format but my problem is when opening the .xls file where the column "H" the volars return modified.

SAP is one of the most sophisticated ERP systems in the world, so you can probably test other export methods by sending the data out in many other formats (csv, txt, etc...)

Example: cell H23 = 1.833 (before opening macro) -> H23 = 1.833 (after opening macro)

what do you mean the value is different before and after opening the macro? your words in the above post show the same number in the same cell. not understanding that.

[rafa.jsilva]

Hi, vba_php!

cell H23 = 1,833 (before opening macro) is when I open the file whithout macro and the value has comma.
cell H23 = 1.833 (after opening macro) is when I open the file with macro and the value show with dot.

When I work with macro my result isn't good and when I open the file manually and paste in file my result is enough.
Attachment 696269
Attachment 696270

[vba_php]

HI!

I cannot view the attachments because of the way you uploaded them. i have no idea what you guys do to make that happen. upload them another way, by pressing the ""go advanced"" button at the bottom of your post and select ""manage attachments"", the hyperlink on that page. thanks. see the image below for what I see when trying to view your attachments:

[rafa.jsilva]

I got save the file extrator_teste only in .xls, when you to open change to .xlsm.

Please, try again to do download.

EXTRATOR_TESTE.xls
123.xls
wrong result.JPG
right result.JPG

[vba_php]

i cannot replicate your issue, so I don't think I'm going to be much help here. sorry.

if you want to give more details about your issue, record a video as proof that the number you're speaking of does indeed change before and after macro. in other words, a video of you opening the file and running the macro. to record a video in windows 10, see here:

https://www.google.com/search?q=wind...+bar+recording

[kvsrinivasamurthy]

Pl attach files as shown in yellow line at the top of the page.

[romperstomper]

Sounds like an issue with your regional settings. Perhaps try:

Please Login or Register  to view this content.

in your second macro.

[rafa.jsilva]

Hi, Rorya!

The local:=true worked

Thank you.
Rafael