| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Excel to PDF by VBA
Hi all, I have normal Adobe Reader 7.0 installed on my PC. Is there
way to create PDF files of excel sheet or specific excel sheet range from excel VBA. Please can any friend help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Excel to PDF by VBA
check it here
http://kb.adobe.com/selfservice/view...8398&sliceId=2 On Feb 9, 1:21*pm, K wrote: Hi all, *I have normal Adobe Reader 7.0 installed on my PC. *Is there way to create PDF files of excel sheet or specific excel sheet range from excel VBA. *Please can any friend help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Excel to PDF by VBA
On Feb 9, 8:37*am, muddan madhu wrote:
check it here http://kb.adobe.com/selfservice/view...Id=328398&slic.... On Feb 9, 1:21*pm, K wrote: Hi all, *I have normal Adobe Reader 7.0 installed on my PC. *Is there way to create PDF files of excel sheet or specific excel sheet range from excel VBA. *Please can any friend help- Hide quoted text - - Show quoted text - Thanks for replying muddan, but i need vba to do this job. and i havent got acrobat, i just have normal adobe reader. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Excel to PDF by VBA
may be this
http://www.tek-tips.com/viewthread.cfm?qid=416162 On Feb 9, 1:47*pm, K wrote: On Feb 9, 8:37*am, muddan madhu wrote: check it here http://kb.adobe.com/selfservice/view...Id=328398&slic.... On Feb 9, 1:21*pm, K wrote: Hi all, *I have normal Adobe Reader 7.0 installed on my PC. *Is there way to create PDF files of excel sheet or specific excel sheet range from excel VBA. *Please can any friend help- Hide quoted text - - Show quoted text - Thanks for replying muddan, *but i need vba to do this job. *and i havent got acrobat, i just have normal adobe reader. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Excel to PDF by VBA
On Feb 9, 7:21*pm, K wrote:
Hi all, *I have normal Adobe Reader 7.0 installed on my PC. *Is there way to create PDF files of excel sheet or specific excel sheet range from excel VBA. *Please can any friend help Use pdf creator....unless of course you have excel 2007 and it's just a saveas..... You need to set up your printable area and then print to the pdf printer.... If you want it to look nice there are a few tricks... If you are using excel 2003 or below, then sometimes you might want to output it into word first and then print it.. Just a few lines of vba.... Regards, Tom Bizannes Sydney, Australia |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create Excel to PDF by VBA
On Feb 9, 1:21*am, K wrote:
Hi all, *I have normal Adobe Reader 7.0 installed on my PC. *Is there way to create PDF files of excel sheet or specific excel sheet range from excel VBA. *Please can any friend help VBA cannot create a pdf on it's own, I use a free version called "PDF ReDirect", been using it for years I have heard xl'07 has it's own pdf creator and you may be able to use VBA to manipulate it. If you have a PDF creator, then you can just use your macro recorder set set the print driver. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
| Can I create a userform in Excel to create an appointment in Outlo | Excel Programming | |||
| create Macro €“ select data, sort by acc no., yr, part no, create P | Excel Programming | |||
| How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
| how to create a combo box in excel - how to create the drop down . | Excel Discussion (Misc queries) | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
