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
|