Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Open Excel using VBA
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Open Excel using VBA
Thank you very much for your response but that does not QUITE work. Basically it does open the other instance of EXCEL. But then it closes it back down. Anyway around this at all. I am new to VBA so dont fully understand it yet. Thank you very much -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=480809 |
#4
|
|||
|
|||
Open Excel using VBA
What happens if you do something in that instance?
Option Explicit Sub testme() Dim xlApp As Object Dim xlWkbk As Object Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set xlWkbk = xlApp.Workbooks.Add End Sub If you don't want that empty workbook hanging around: Option Explicit Sub testme() Dim xlApp As Object Dim xlWkbk As Object Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set xlWkbk = xlApp.Workbooks.Add xlWkbk.Close savechanges:=False End Sub moglione1 wrote: Thank you very much for your response but that does not QUITE work. Basically it does open the other instance of EXCEL. But then it closes it back down. Anyway around this at all. I am new to VBA so dont fully understand it yet. Thank you very much -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV formatted files open odly in Excel 2000 | Excel Discussion (Misc queries) | |||
Unable to open excel document across a network. | Excel Discussion (Misc queries) | |||
Open an existing excel speadsheet, opens Excel but not the file?? | Excel Discussion (Misc queries) | |||
How do i open excel doc in works? | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) |