![]() 'Wait until the print job has entered the print queue If Dir(sPDFPath & sPDFName) = sPDFName Then Kill (sPDFPath & sPDFName)ĪctiveSheet.PrintOut copies:=1, ActivePrinter:="PDFCreator" Shell "taskkill /f /im PDFCreator.exe", vbHide If pdfjob.cStart("/NoProcessingAtStartup") = False Then 'Check if PDFCreator is already running and attempt to kill the process if so Set pdfjob = New PDFCreator.clsPDFCreator 'Activate error handling and turn off screen updates ![]() If IsEmpty(ActiveSheet.UsedRange) Then Exit Sub 'Check if worksheet is empty and exit if so SPDFPath = ActiveWorkbook.path & Application.PathSeparator '/// Change the output file name here! /// ' Designed for early bind, set reference to PDFCreator 'Author : Ken Puls ('Macro Purpose: Print to PDF file using PDFCreator The code I have so far for saving a sheet as PDF in PDF Creator 1.7.3 is as following, it works flawlessly but only saves your sheet to PDF and doesnt add a watermark: Version 1.7.3 does support Excel VBA, but this version doesnt support adding watermarks. You can setup the program to automatically add a PDF as a background to all your PDF's, however v2.0 and v2.1 do not support Excel VBA. I've been looking into PDFCreator, and PDFCreator2.0 and 2.1 support adding PDF backgrounds to your PDF. I've searched the internet far and wide for an solution but couldn't find any for this, many questions regarding this were unanswered.Īs far as I know this isn't possible in Excel itself and will require a 3rd party program. ![]() Reason for this is that the header and footer settings in Excel just aren't advanced enough and can't offer real high quality pictures. I'd like to add a PDF-background to this PDF, like a watermark. ExportAsFixedFormat method), works flawlessly. There is an inconsistency well beyond what encoding is used.I have a sheet that gets saved as PDF (currently using the. Apparently different fonts are being embedded in the PDF files. It is not the CID Identity-H encoding, though! You should contact Microsoft to ascertain why their PDF files are so bloated in size. The second and third PDF files you reference are produced via Microsoft's tools, neither of which are highly regarded in terms of the quality or efficiency of their PDF production. (3) None of the three methods of producing PDF that you give examples for are Adobe products or have anything to do with Adobe Acrobat's PDF creation capability. (2) There is no feature within Acrobat Pro, including within the Preflight functions, to eliminiate existing Identity-H encoding. There is no penalty in terms of your ability to view, print, search, or even edit such PDF files. DIfferent PDF creators use this encoding based upon which characters in a font are actually used, typically when non-ASCII or Western Latin characters (such as any symbolic characters are used. (1) There is nothing “invasive” about Identity-H encoding. Is there are a solution to reduce this INVASIVE Identity-H encoding ? ![]() Harlow Solid Italic,Italic TrueType WinAnsiĬalibri Light,Italic CID TrueType Identity-H HarlowSolidItalic,Italic TrueType WinAnsi For our caritative association, we have a small news paper of one page, since the beginning of this publication except the one page text, the fonts and the logo image was not changed and depending of the evolution of the means of creation we have 3 types of pdf files.Įxcept the size, the aspect of the pdf on screen or on printer is exactly the same ! I don't understand what is the advantage of Identity-H encoding. The only thing you might try is use of other fonts that are much more restricted in the number of glyphs they support, probably meaning that you may need to license fonts other than the Windows system fonts. When encountering such fonts, some if not most PDF generators will use CID Identity-H encoding. One of the major changes that most users are not aware of is that in the transition from Windows 7 to Windows 8.x to Windows 10, the system fonts within Windows (such as Arial, Times New Roman, etc.) grew dramatically in size in terms of the numbers of glyphs defined in those fonts (to support more languages, special symbolic characters, etc.). You did mention your transition from Windows 7 to Windows 10. You should contact that company's tech support to get a fix from them for their software. It seems like this “Bing Mailroom” software is making very poor assumptions about the PDF files that it will need to interpret. Furthermore, any software that is attempting to interpret text within a PDF file should be able to deal with such encoding. There are absolutely no settings in any Adobe preferences or options to avoid this encoding. It is often used when large character sets are used or non-ASCII characters are referenced. Such encoding is perfectly valid per the PDF specification. There is no method of eliminating use of CID Identity-H encoding when creating PDF files.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |