L
Leroy
Is it possible to make a macro or something in access 2003 that will export
two reports but append the second report on a new page of the same word
document?
I was able to create a macro in word that would merge two documents, I'm
just curious if doing something similar in access would be possible to make
the job less confusing. Basically I have a macro that already exports the two
word documents, and they have to open one of them and run this macro.
--------------------------Word Macro -------------------------------
Sub Foo()
Application.ScreenUpdating = False
Documents.Add
With Application.FileSearch
'Search in foldername
.LookIn = "C:\test"
.SearchSubFolders = False
Selection.InsertFile FileName:=("Cover.Doc"), _
ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.InsertBreak Type:=wdPageBreak
Selection.InsertFile FileName:=("Blotter.doc"), _
ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.InsertBreak Type:=wdPageBreak
End With
End Sub
-------------------End Macro-----------------------------------
Is this macro possible in Access or is there another way of automating this
process? Any information would be greatly appreciated.
two reports but append the second report on a new page of the same word
document?
I was able to create a macro in word that would merge two documents, I'm
just curious if doing something similar in access would be possible to make
the job less confusing. Basically I have a macro that already exports the two
word documents, and they have to open one of them and run this macro.
--------------------------Word Macro -------------------------------
Sub Foo()
Application.ScreenUpdating = False
Documents.Add
With Application.FileSearch
'Search in foldername
.LookIn = "C:\test"
.SearchSubFolders = False
Selection.InsertFile FileName:=("Cover.Doc"), _
ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.InsertBreak Type:=wdPageBreak
Selection.InsertFile FileName:=("Blotter.doc"), _
ConfirmConversions:=False, Link:=False, Attachment:=False
Selection.InsertBreak Type:=wdPageBreak
End With
End Sub
-------------------End Macro-----------------------------------
Is this macro possible in Access or is there another way of automating this
process? Any information would be greatly appreciated.