Many Thanks Bob
I removed the 3 lines of code and it works perfect.
Now, I need a macro to simply open a new instance of Excel.
So, I tried copying the workable code to a new macro and rem'd out:
'Set oWB = oXL.Workbooks.Open("C:\documents and settings\default\my documents\
computerclasshandouts.xls")
Well, it didn't do anything except flash or blink the existing copy of Excel
that the original macro is in.
Can I please ask for help one more time ?
Matt@Launchnet
Bob Phillips wrote:
LOL! Yes, my code will do that.
This bit
'...
is where you should do what you want to do. If you don't want to do
anything, just have the extar instance of Excel, remove
Set oWB = Nothing
oXL.Quit
Set oXL = Nothing
Good Morning Bob
[quoted text clipped - 44 lines]
Matt @ Launchnet
--
Please take a look at
www.openoursite.com and you will see how I want to
use.
God Bless for helping
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200706/1