Re: Any way to get new instance of Excel on double-click?

Tech-Archive recommends: Fix windows errors by optimizing your registry



That did it! I now see 2 EXCEL processes after double-clicking.

Thanks! BTW, how'd you know? Help wasn't very helpful, so off to the
newsgroup I went.

ken


"Peter T" <peter_t@discussions> wrote in message
news:%23r6$8Df9FHA.3636@xxxxxxxxxxxxxxxxxxxxxxx
> try -
>
> xlApp.IgnoreRemoteRequests = True
>
> You may want to trap the original value and restore before xlApp.quit
>
> "Ken Shaffer" <noemail@xxxxxxxx> wrote in message
> news:#DsdYpe9FHA.500@xxxxxxxxxxxxxxxxxxxxxxx
> > Is there a way that double-clicking will bring up a new instance of
Excel
> so
> > that the spreadsheets being manipulated via VB won't be seen? Perhaps in
> the
> > VB program itself there might be an option to set so that windows thinks
> > Excel hasn't started yet and so creates a new instance to open it.


.


Quantcast