Displaying New Excel Workbook

[Travis G]

I have a VBA project in Word that can create and populate Excel Workbooks and Outlook Messages. I can show the Message to the user when I'm done with it, but I can't figure out how to show the Workbook.

VBA in a Word project, what is the method to show an Excel Workbook?

This is the code I use for the Outlook Message.

Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
 
Set objOutlook = New Outlook.Application
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
 
'Fill out Reciepents, Subject, add Attachments here.
 
objOutlookMsg.Display
AppActivate myMessageSubject, True

[Granty]

Dim XLApp as Excel.Application
Dim XLBook as Excel.Workbook

Set XLApp = New Excel.Application
Set XLBook = XLApp.Workbooks.Open("C:\MyFile.xls)

XLApp.Visible = True

'Do stuff

XLApp.Quit
Set XLBook = Nothing
Set XLApp = Nothing

[Travis G]

Thanks. I was looking for some method on XLBook instead of XLApp. That was incredibly frustrating.