Data from web, replace a "." with a "," -problem

[Masun]

Hi all,

I have a workbook where i get some data from the web. Earlier the data i collected came in the right format: numbers where separated with a "," so it could be calculated. To get new data from the web i had a simple macro that refreshed my workbook.

Please Login or Register  to view this content.

.

Now the webpage has made some changes. They have replaced the "," with a "." so when i collect the data from the web my formulas in the workbook cant be calculated beacuse its not a number. My solution to this was to record a macro where I replaced all the "." with a ",".

Please Login or Register  to view this content.

When i run the macro it seems like the refresh part of the code takes a little bit too long so the replacement is done before the refreshment. If i just step myself through the code with F8 it works but when i run the entire code the replacement is done before the refresh (getting new data from the web).

The entire code is those two parts above:

Please Login or Register  to view this content.

How can i make this work? Any ideas?

/Masun

[nathansav]

doevents may help, but not sure. put it after the refreshall line

[nilem]

Hi Masun,
could you upload a file with an example of your data

[Masun]

Thanks for your replay.

Ok, uploaded the file...

[nilem]

Masun,
maybe it would be suitable for you

Please Login or Register  to view this content.

[Masun]

Hi Nilem,

Thank you very much. That solution works. But there are more tables from other sites that needs to be "hardcoded" instead of the simplier way of refreshing the workbook. Do you have any idea of why the "refresh thing" in the code is done before the "replacement thing"...

/Masun

[Marc L]

Hi,

'cause of the QueryTable's BackgroundQuery & Refresh properties as you must read into the code ‼

[Masun]

Ok,

How do i change my code so the "QueryTable's BackgroundQuery & Refresh properties" are done in correct order? I want to get the data from the web and when thats done i want to replace the "." with the ","

/Masun