It shows : "221129 Offerte STRABAG BMTI GmbH .pdf"
And as mentioned, it is likely that Windows does not like the space before ".pdf"?
Rename a file with that and see if it accepts it, and you can open it from withing Access.
I have just tried with windows explorer on one of my files and it did not complain, despite it looking odd?
GCCS Passengers - G. pdf
Word does not object
but where is your path?Code:With wdApp.ActiveDocument .SaveAs Filename:=StrMMPath & strPDFName & " .pdf", FileFormat:=wdFormatPDF, AddToRecentFiles:=False '.Close SaveChanges:=False End With
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
TY Very much Welshgasman it worked!!! It was the space before ".pdf"And as mentioned, it is likely that Windows does not like the space before ".pdf"?
Rename a file with that and see if it accepts it, and you can open it from withing Access.
I have just tried with windows explorer on one of my files and it did not complain, despite it looking odd?
GCCS Passengers - G. pdf
Word does not object
but where is your path?Code:With wdApp.ActiveDocument .SaveAs Filename:=StrMMPath & strPDFName & " .pdf", FileFormat:=wdFormatPDF, AddToRecentFiles:=False '.Close SaveChanges:=False End With
as prompted to you 9 posts ago. Recommend you read all the posts and respondIt was the space before ".pdf"