open other excel application by vba

[ppyxl]

Hi,

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

Thanks

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>