SimonOrtmann
asked on
Printing to PDF file from excel - some problem with fonts - I think
When I print to PDF by hand it works fine, but when I print from a macro the size becomes 10 times bigger, and is not recognized as a pdf file.
I have deactivated rely on system fonts.. in the ADOBE pdf-printer
The code I use is:
PrintFileName = "xxx2.pdf"
hj = ActiveSheet.PrintOut(1, 1, 1, False, "Adobe PDF på Ne04:", True, False, PrintFileName)
If I try opening the file in Adobe Illustrator I get the message:
Font not found on the system. Missing font has been substituted
Then the file is opened, but the text is nonsense
I attach the file if it is of any help. Test3 is the file written 'by hand', xxx2 is the file written by the macro
test3.pdf
xxx2.pdf
I have deactivated rely on system fonts.. in the ADOBE pdf-printer
The code I use is:
PrintFileName = "xxx2.pdf"
hj = ActiveSheet.PrintOut(1, 1, 1, False, "Adobe PDF på Ne04:", True, False, PrintFileName)
If I try opening the file in Adobe Illustrator I get the message:
Font not found on the system. Missing font has been substituted
Then the file is opened, but the text is nonsense
I attach the file if it is of any help. Test3 is the file written 'by hand', xxx2 is the file written by the macro
test3.pdf
xxx2.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER