Topic
Append many documents in a new one
Page d'accueil ' Communauté ' Automation et VBA ' Appliquer de nombreux documents en un seul
- Ce sujet contient 4 réponses, 2 participants et a été mis à jour pour la dernière fois par Nicolas Beaupré, le il y a 19 années et 3 mois.
-
AuteurMessages
-
08.02.2006 à 02:08 #34962Nicolas BeaupréParticipant
Hi,
Is there a way in VBA to append documents? (or pages) In Flexpro, I can open an empty document and, with drag and drop, I insert another existing document in the new one. It is added at the end of the open document. How may I do that in VBA?For example, in my application, I got a lot of small “report_x” document. I want to create a new document named “GlobalReport” wich is the sum of all the others document. After doing this, I’ll be able to edit the pages number of “GlobalReport” and print it alone.
Thanks!
08.02.2006 à 02:08 #34966Nicolas BeaupréParticipantHi,
Is there a way in VBA to append documents? (or pages) In Flexpro, I can open an empty document and, with drag and drop, I insert another existing document in the new one. It is added at the end of the open document. How may I do that in VBA?For example, in my application, I got a lot of small “report_x” document. I want to create a new document named “GlobalReport” wich is the sum of all the others document. After doing this, I’ll be able to edit the pages number of “GlobalReport” and print it alone.
Thanks!
09.02.2006 à 02:10 #34963Bernhard KantzParticipantIn FlexPro there is no method to append a document to another document.
But there is the possibility to select the shapes of the document. Then you can use the [b]Copy[/b] and the [b]Paste[/b] method.
Example:
[code]
Dim oSourceDoc As Document
Dim oDestDoc As Document
Dim i As IntegerSet oSourceDoc = ActiveDatabase.RootFolder.Object(“Doc1”, fpObjectTypeDocument)
Set oDestDoc = ActiveDatabase.RootFolder.Object(“Doc2”, fpObjectTypeDocument)Dim oPage As Shapes
Set oPage = oSourceDoc.Pages(1)
For i = 1 To oPage.Count
oSourceDoc.Select
oSourceDoc.Selection.Collapse
oPage.Item(i).Select
oSourceDoc.Selection.Copy
oDestDoc.Select
oDestDoc.Selection.Paste
oDestDoc.Selection.Collapse
Next i
[/code]10.02.2006 à 00:20 #34964Nicolas BeaupréParticipantThanks for the code! It works, but I had to add these lines :[code] oSourceDoc.Select
[b]oSourceDoc.Open = True[/b]
oSourceDoc.Selection.Collapse
oPage.Item(i).Select
oSourceDoc.Selection.Copy
oDestDoc.Select
[b]oDestDoc.Open = True[/b]
oDestDoc.Selection.Paste
oDestDoc.Selection.Collapse[/code]
Otherwise, the operations .Collapse and .Paste couldn’t work when the documents are closed.Also, this code copies the shapes in the first page of my document. Suppose I add a new page in the document [code]Dim oNewPage As Shapes
Set oNewPage = oSourceDoc.pages.Add[/code] How can I select the new page so the shape will be copied in it ?Thanks
10.02.2006 à 00:51 #34965Bernhard KantzParticipantYou can use the methods [b]NextPage[/b] and [b]PreviousPage[/b] of a DocObjectSelection object.
[code]
oDestDoc.Selection.PreviousPage
oDestDoc.Selection.NextPage
[/code] -
AuteurMessages
- Vous devez être connecté pour répondre à ce sujet.