If you get tired of pushing this one through the frontier, you might check
out the code at Ron's site that does this (particularly since you are
programming from within Excel). It also illustrates that you can often
avoid selecting and activating.

http://www.rondebruin.nl/tips.htm

--
Regards,
Tom Ogilvy

"Paul - NottsUK" <PaulNottsUK@discussions.microsoft.com> wrote in message
news:3EFDA383-028C-44FB-A202-A856F7F7A564@microsoft.com...
> Donna,
>
> In one version of\my code I tried using appxl.quit and it closed the
> instance I was in. From the reply before yours I've got an idea of a
slightly
> different approach that I'm going to try.
>
> With regard to your further comment I often find myself pushing Excel into
> little known areas and even have people telling me that what I'm trying to
do
> isn't possible. However, I carry on and usually find a solution. Sometimes
I
> publish it. I'll mail you.
>
> "donna.gough@hydro.com" wrote:
>
> > Paul,
> > Rather than Set appXL=Nothing
> > should you be doing:-
> > appXL.application.quit
> >
> > I am not an expert at this...I have muddled my way through writing a
> > macro in PCDMIS that will import data into Excel. I have found it
> > difficult finding any help sites that provide any syntax in terms of
> > what you need to declare and how to use them etc......do you know of
> > any that would help me in the future?
> >
> >