Thread: Error no. 1004
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Error no. 1004

Why don't you add a objXL.Visible = True so you can see what is happening?
When you say you run it a second time, you mean you're instantiating another
instance of Excel? If so I don't know why the second instance should be
affected by the first. If not, then you really didn't post the code you're
running which makes it harder to help you.

--
Jim Rech
Excel MVP