Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combine a word doc and excel spreadsheet
Message
De
20/08/2010 13:46:06
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
20/08/2010 11:42:05
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01477546
Message ID:
01477620
Vues:
41
>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform