View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba,microsoft.public.office.developer.automation,microsoft.public.access.modulesdaovba
Clif McIrvin[_2_] Clif McIrvin[_2_] is offline
external usenet poster
 
Posts: 23
Default Excel won't close properly

"Dale Fye" wrote in message
...
OK,

After a little more research, I found that I was leaving out the
reference to the application object when I used the "With Selection"
syntax. When I replaced:

With Selection

with

With xlApp.Selection

There were also a couple of instances where I was using a syntax that
looked like:

Seletion.Font.Bold

or something along those lines. When I prepended the application
object to all of these, it resolved my problems.

Hope this helps someone else.
Dale



Appreciate it Dale. This may indeed be of use for me. I don't have
opportunity to investigate just now, but am saving this post for future
reference.

--
Clif