[Loop] - Can I export/ print Loop workspaces to a target document like pdf, for the purpose...

Thanks a lot for the reply! If you dont mind, I would like to elobarate my question in english. First problem is that I would like to add a word document (coverpage) to my word document. This coverpage is already prepared. But I have to merge this two word documents. How is it possible? The second problem is when I add a header in the coverpage, it appears in the other pages also. How can I fix the header just in the first page? Third problem is that I have deleted some references in the bibliography, when I update the bibliography, the deleted references don't disappear. How can I fix it?
<br />Kind regards
<br />

If the file is already open use a FOR EACH loop and the LIKE operator to compare all filenames if they match.

Sub Test()

Dim Wb As Workbook



For Each Wb In Workbooks

If Wb.Name Like "*20190426*" Then

'Reference found

Exit For

End If

Next

End Sub

Otherwise you have to search for all files in the specific directory and compare that names. If all files are in a single directory you can use DIR to find the files.

Sub Test()

Dim Wb As Workbook

Dim Path As String, FName As String



Path = "Z:\"

FName = Dir(Path & "*.xlsx")

Do While FName <> ""

If FName Like "*20190426*" Then

'Reference found, open the file

Set Wb = Workbooks.Open(Path & FName)

Exit Do

End If

FName = Dir

Loop

End Sub

Otherwise I suggest that you download my FileSearch class to search for the file.

https://www.dropbox.com/sh/tuqw83m802x6jn7/AAALmSmkkRszpreiM8AUjx7va?dl=1

Andreas.

Same as if I print a pdf document, then it also works fine.

If the preview in pdf works fine there is no word issue. Office use the print service from the MacOSX. You should have a look to the printer software/ driver in MacOSX, maybe you have the wrong driver installed.

Hello

Thanks for the answers. But that's not what I'm looking for.

I search for a solution to "unlink" the fields in header and footer. For example a date field, which updates when I print or open the file.

In word I can do this with a macro, but in excel and powerpoint that solution didn't worked.

No, in the preview it shows all pages as well. However, it I print from the preview, the page selection works fine. Same as if I print a pdf document, then it also works fine.

Regards,

Rolly