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?