| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
| Size Matters - minimizing file size | Excel Programming | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| code to check file size everytime an Excel file is opened | Excel Programming | |||
| How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming | |||
Hybrid Mode
