Window refresh

[meg99]

using 2003. I have a form that displays holiday dates imported from
Excel in a listbox. The user can change various things and then
update the selected Project calendar. On the form is a command button
labeled "Add or Delete Holiday" The user can use this to open the
Excel workbook and add or delete a holiday.

Problem: When the user closes Excel, the prgram returns to the user
form but with the artifacts of the Excel spreadsheet filling what
should be the Project window/view. Closing the form will restore the
view. Grabbing the edge of the window with the mouse and moving it
slightly will restore the view. If I set up an interupt in the code
and step thru it, the view gets refreshed. I have tired to move the
edge of the Project window prgrammatically but that doesn't work. I
have tried "Application.Activewindow.Refresh", but that creates an
error. I can't seem to get rid of the Excel spreadsheet artifact and
restore the Project window/view.


Anybody have a clue?

meg99

 

[Rod Gill]

How about minimizing or hiding the Excel application object?

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[meg99]

How about minimizing or hiding the Excel application object?

Rod,
I do that prior to quitting Excel:
XLapp.visible = False
Xlapp.quit

The Excel artifact remains - that is - I can still see the spreadsheet
and cells etc. It is a refresh issue I don't know how to solve.

meg99