Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combine a word doc and excel spreadsheet
Message
From
20/08/2010 13:46:06
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
20/08/2010 11:42:05
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01477546
Message ID:
01477620
Views:
40
>>>one of my apps create a series of letter/xls combination to send out via email (wwipstuff.dll) but the dll i use (version 5.45.0) does not work with 2 attachments. so i changed it to zip the 2 together and attach the zip file
>>>that works fine
>>>
>>>but some users claim not o be able to open zip files
>>>
>>>so i thought maybe there is some autoamation coe to insert the xls into the end of the .doc file
>>>
>>>
>>>then all I have to email is one word file :-)
>>
>>Just do it manually in Word, while recording a macro. Then translate the macro into Fox, using automation.
>
>
>i know that. but I don't know how to do it in word. inserting an object inserts a blank exls, inserting a file inserts the bnary garbage...

This is what I got inserting a (simple) xls into a (simple, one page) .doc in word/excel 2003:
Selection.InsertFile FileName:="PathToMySheet.xls", Range:="" _
        , ConfirmConversions:=False, Link:=False, Attachment:=False
And it showed up. Though, it asked a few questions during the process, and it popped up a couple of dialogs - but I guess that's how it determined the parameters.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform