|
-
Jul 17th, 2003, 01:50 PM
#1
Thread Starter
Addicted Member
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
Travis, Kung Foo Journeyman
Web Standards: HTML 4.01, CSS Level 2, ECMA 262 Bindings to DOM Level 1, JavaScript 1.5 Guide and Reference
Perl: Documentation, Learn Perl, Llama, Camel, Cookbook, Perl Monks, Perl Mongers, O'Reilly's Perl.com, ActiveState, CPAN, TPJ, and use Perl;
OSS: Mozilla, MySQL (Manual)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|