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" wrote in message
...
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.

" 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?