CreateObject from Template
ps.
If you haven't turned your pc off since your last test, try this:
Close all the versions of excel that you have open (that you can see)
Hit alt-ctrl-delete to show the windows Task manager.
Look at the Applications tab. You shouldn't see excel anywhere.
Look at the Processes tab.
You may find that you have lots and lots of excel.exe's still running (but
they're not visible) to you (the user).
You can end these processes, but you won't get a chance to save any work.
When I'm hiding excel and testing, I want a method of showing those instances of
excel.
I use a .vbs file with this in it:
dim myXL
On Error Resume Next
Set myXL = GetObject(, "Excel.Application")
If Err.Number = 429 Then
msgbox "Excel is not running"
else
myxl.visible = true
end If
On Error GoTo 0
Set myxl = nothing
You can copy this (starting with Dim and ending with Set) and paste it into
NotePad.
Then save the file as UnHideExcel.VBS in a nice safe location on your pc.
Then you can close any visible instances of excel
run that .vbs file
close that newly shown instance of excel
run that .vbs file
close the next newly shown instance of excel
(do those last two steps until you get the "excel is not running" message.)
Dave Peterson wrote:
<<snipped
--
Dave Peterson
|