View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Launchnet via OfficeKB.com Launchnet via OfficeKB.com is offline
external usenet poster
 
Posts: 47
Default How to open a new instance of EXCEL and .xls file

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