Hi,

any one knows how to use vba from this excel application to create
new excel appication?

Thank

--
ppyx
-----------------------------------------------------------------------
ppyxl's Profile: http://www.excelforum.com/member.php...fo&userid=3611
View this thread: http://www.excelforum.com/showthread.php?threadid=55930

Dim xlApp As Object
Dim xlWB As Object

Set xlApp = CreateObject("Excel.Application")

' if you want to make it visible
xlApp.Visible = True

'and to do stuff with it
Set xlWB = xlApp.Workbooks.Open("C:\MyFiles\myFile.xls")

'and at the end
xlWB.Save
xlWB.Close
xlApp.Quit
Set xlWB = Nothing
Set xlApp = Nothing



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ppyxl" wrote in
message ...

Hi,

any one knows how to use vba from this excel application to create a
new excel appication?

Thanks


--
ppyxl
------------------------------------------------------------------------
ppyxl's Profile:
http://www.excelforum.com/member.php...o&userid=36116
View this thread: http://www.excelforum.com/showthread...hreadid=559307