Displaying New Excel Workbook
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.
VB Code:
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