Re: Any way to get new instance of Excel on double-click?
- From: "Ken Shaffer" <noemail@xxxxxxxx>
- Date: Thu, 1 Dec 2005 08:05:17 -0500
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.
.
- Follow-Ups:
- References:
- Any way to get new instance of Excel on double-click?
- From: Ken Shaffer
- Re: Any way to get new instance of Excel on double-click?
- From: Peter T
- Any way to get new instance of Excel on double-click?
- Prev by Date: RE: Importing Data from Access
- Next by Date: RE: VBA, SQL, and multiple versions of Excel
- Previous by thread: Re: Any way to get new instance of Excel on double-click?
- Next by thread: Re: Any way to get new instance of Excel on double-click?
- Index(es):