Stop VBA and then start again?

[tejay]

Hi All,

I am pre-populating cells with a formula from VBA.

The formulas are inserted into the cells ok, but the data will only populate when I stop VBA.
The formula instructs excel to download data from an external source.

I have tried the Application.Wait method for 20 seconds, nothing will happen until I stop VBA.

The data I am downloading is from Bloomberg if anyone has experience with this.

Thanks

[Kenneth Hobson]

Have you tried DoEvents or the more likely Worksheets("Sheet1").Calculate?

[mikerickson]

never mind

[tejay]

Hi Kenneth,

I have tried worksheet calculate.
This line is before I instruct VBA to wait for 20 seconds.

DoEvents I haven't tried, I will look into this further.

Any other suggestions would be appreciated.

Thanks

[tejay]

Hi all,

It turns out Bloomberg had its own Application I had to run to refresh the data.

If anyone else is interested though, this was the generic setup I had;

Please Login or Register  to view this content.