View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How to open a new instance of EXCEL and .xls file

Matt,

Just to check, can you post the actual code that you now have?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Launchnet via OfficeKB.com" <u20911@uwe wrote in message
news:73cf7a1889582@uwe...
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