View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michel Angelosanto Michel Angelosanto is offline
external usenet poster
 
Posts: 6
Default how to open a workbook when application excel is running ?

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