you probably ned to open a new excel application and launch the web workbooks
with the new application

Set obj = createobject("Excel.application")

"Barb Reinhardt" wrote:

It would be helpful to see what you've tried.

"Michel Angelosanto" wrote:

hello,

I have an application wich runs Internet explorer and open a distant
workbook but the workbook do not open because excel macro is running.

Has a command in vba to let excel allow openning the workbook and continue
execution of the macro?

I want to open the workbook, read the data in it and close it, then open
other workbook read data and close it etc ...
I have tried DoEvents without success.

Thanks
--
Michel Angelosanto, Bordeaux
Dernières mises Ã* jour du site Voyage au pays Internet
http://angelosa.free.fr/index.php?t=8