something more fast then that...openfile-refresh-save-close

[squatter87]

hi guys!

this macro is little bit inefficient, need 2 seconds for every file...and for >300files is slow.
I need to update the stock price in every file (2 or 3 times every day) and then send other data calculated in theese file with new prices to another excel to compare all selected data.
Can you optimize that?
thanks
Alessio

Please Login or Register  to view this content.

[Keebellah]

Why have you included

Please Login or Register  to view this content.

That seems unnecessary here

You should also stop all events and calculations before you start the loop and reset them after you the loop is completed

[Keebellah]

Your code modified

Please Login or Register  to view this content.

[squatter87]

thanks Kebe!!! It works very well, I need to put Workbooks(Dir(Myfile)).RefreshAll for refresh the stock price of every file...but is more fast!!

[Keebellah]

Okay, clear, well, happy it speeded it up