|
PDF file size
In 2003 I used Acrobat Distiller in marcos and created a pdf file of 300 kb.
When I used the same code in 2007 I ended up with a pdf file size of 14,000 kb. In 2007 I tried ExportAsFixedFormat with minimum quality and get a file size on the same worksheet of 900 kb. Is there any way to reduce the pdf file size? |
PDF file size
Hi Mark
See if your used range is not to big Is the shortcut Ctrl-end Select the last cell with data ? If you send a selection do you have the same problem then ? I have code examples here to test http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark" wrote in message ... In 2003 I used Acrobat Distiller in marcos and created a pdf file of 300 kb. When I used the same code in 2007 I ended up with a pdf file size of 14,000 kb. In 2007 I tried ExportAsFixedFormat with minimum quality and get a file size on the same worksheet of 900 kb. Is there any way to reduce the pdf file size? __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com |
PDF file size
I have the range set to print just the part of the sheet I want in all three
cases. The pdf file looks the same in all three cases, but the file size is different. I have tried your code for the ExportAsFixedFormat with the quality seeting to minimum and get the 900 kb pdf file size. With Acrobat Distiller in Excel 2003 I get a pdf file size of 300 kb using the same print range. When you have to e-mail 50 pdf files, 300 kb works better than 900 kb. Thank you for your reply, I have learned a lot reading your codes. "Ron de Bruin" wrote: Hi Mark See if your used range is not to big Is the shortcut Ctrl-end Select the last cell with data ? If you send a selection do you have the same problem then ? I have code examples here to test http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark" wrote in message ... In 2003 I used Acrobat Distiller in marcos and created a pdf file of 300 kb. When I used the same code in 2007 I ended up with a pdf file size of 14,000 kb. In 2007 I tried ExportAsFixedFormat with minimum quality and get a file size on the same worksheet of 900 kb. Is there any way to reduce the pdf file size? __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com |
PDF file size
Hi Mark
There are more problems with the add-in and i hope they will make a new version soon I hate it that hyperlinks to another sheet and also hyperlinks worksheet functions not working in the PDF. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark" wrote in message ... I have the range set to print just the part of the sheet I want in all three cases. The pdf file looks the same in all three cases, but the file size is different. I have tried your code for the ExportAsFixedFormat with the quality seeting to minimum and get the 900 kb pdf file size. With Acrobat Distiller in Excel 2003 I get a pdf file size of 300 kb using the same print range. When you have to e-mail 50 pdf files, 300 kb works better than 900 kb. Thank you for your reply, I have learned a lot reading your codes. "Ron de Bruin" wrote: Hi Mark See if your used range is not to big Is the shortcut Ctrl-end Select the last cell with data ? If you send a selection do you have the same problem then ? I have code examples here to test http://www.rondebruin.nl/pdf.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mark" wrote in message ... In 2003 I used Acrobat Distiller in marcos and created a pdf file of 300 kb. When I used the same code in 2007 I ended up with a pdf file size of 14,000 kb. In 2007 I tried ExportAsFixedFormat with minimum quality and get a file size on the same worksheet of 900 kb. Is there any way to reduce the pdf file size? __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3949 (20090319) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3949 (20090319) __________ The message was checked by ESET Smart Security. http://www.eset.com |
| All times are GMT +1. The time now is 04:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com