Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel does not quit

I use VB in an Access database to Launch excel. It pastes data into
cells, formats, etc. All the references created are set to Nothing
before terminating. But when I do xl.Quit, nothing happens. No error,
Excel.exe just stays open endlessly. The only way I've found I could
terminate excel would be to manually select excel in the task manager
process list and terminate it. This isn't a very efficient way of
working considering this process creates 20+ excel files. I have seen
many postings regarding this issue but nothing has worked.
Fortunately, I have narrowed down and found the 2 lines of code that
seem to be causing this issue. It happens when I try to freeze
panes. I have run the automation without the 2 lines and it works
fine. I do not know of any other lines of code to do a freeze pane.
If anyone know how to force excel to quit or another way of coding the
below 2 lines, I would greatly appreciate.

2 troublesome lines of code causing issue:
xl.ActiveCell.Offset(9, 7).Select
xl.ActiveWindow.FreezePanes = True

Thanks in advance

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel won't quit from VB.NET Atchoum Excel Programming 1 October 15th 05 10:13 PM
Excel won't quit JRS Excel Discussion (Misc queries) 1 September 27th 05 04:31 AM
vba advice how 2get a input box to quit by entering the word quit+ 4 a msgbox to disp RELWOD85[_4_] Excel Programming 3 August 1st 05 07:11 PM
Excel Won't Quit Rex Excel Programming 13 May 11th 05 01:51 PM
Excel won't quit Jeff[_23_] Excel Programming 0 October 24th 03 05:14 PM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"