View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Open Excel using VBA

I'm not sure why you want another instance of excel, but...


Option Explicit
Sub testme()
Dim xlApp As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
End Sub



moglione1 wrote:

Hi all,

Can somebody please provide me with the VBA code that opens a new Excel
Application and not Excel Workbook.

I.e. I need two instances of Excel running - 1 that contains the code
to open the second instance.

THANKING YOU ALL

--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=480809


--

Dave Peterson