Re: $$Excel-Macros$$ xls to Pdf in VBA error
Dear Prabhu, Please try through below Code. Sub OnlyforActivesheet() On Error Resume Next sh = ActiveSheet.Name ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=\ sh .pdf, Quality:=xlQualityStandard, OpenAfterPublish:=True On Error GoTo 0 End Sub On Thu, Sep 1, 2011 at 10:41 PM, Prabhu prabhugate...@gmail.com wrote: Hi Noor, It is working.. If i needs to create PDF only for active sheet then how to change the above VBA code. Plz help regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ xls to Pdf in VBA error
Hi Noor, It is working.. If i needs to create PDF only for active sheet then how to change the above VBA code. Plz help regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ xls to Pdf in VBA error
Dear Sajid, Please change blue color path as per your system.. This code is working fine in my systems.. *Once again.try..* ** *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * On Tue, Aug 30, 2011 at 2:06 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear sir, I have copy below code and paste in excel 2003 but it shows some error and its not working in my all three systems. I have attached that image in my attachment. Please co-operate me for accomplish my project. awaiting your reply sajid memon -- Date: Mon, 29 Aug 2011 20:01:33 +0530 Subject: Re: $$Excel-Macros$$ xls to Pdf in VBA From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear KBJ, W/S... That converter is working fine on my system.. press alt+F11 and Paste it code in Module and Press F5. I hope it will work fine.. Sub exltopdf_converter() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1) ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False end Sub On Mon, Aug 29, 2011 at 3:35 PM, Advocate kbj msma@gmail.com wrote: dear Noorain Ansari (Assalamulaikum) as per your tryit.xls its not working. plz give me detail. with advance Happy Eid Mubarak to all. sajid memon On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sajid, As per your requirement Please try blow VBA code to Convert Excel file in PDF. Change path as per ur conviniece.. See attached sheet *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query *i don't want to use any other converter software or online website.* ** awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ xls to Pdf in VBA error
Hi Noorian, How it will automatically save PDF Format in 2003 Version...is it available.. -- *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sajid, Please change blue color path as per your system.. This code is working fine in my systems.. *Once again.try..* ** *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * On Tue, Aug 30, 2011 at 2:06 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear sir, I have copy below code and paste in excel 2003 but it shows some error and its not working in my all three systems. I have attached that image in my attachment. Please co-operate me for accomplish my project. awaiting your reply sajid memon -- Date: Mon, 29 Aug 2011 20:01:33 +0530 Subject: Re: $$Excel-Macros$$ xls to Pdf in VBA From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear KBJ, W/S... That converter is working fine on my system.. press alt+F11 and Paste it code in Module and Press F5. I hope it will work fine.. Sub exltopdf_converter() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1) ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False end Sub On Mon, Aug 29, 2011 at 3:35 PM, Advocate kbj msma@gmail.com wrote: dear Noorain Ansari (Assalamulaikum) as per your tryit.xls its not working. plz give me detail. with advance Happy Eid Mubarak to all. sajid memon On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sajid, As per your requirement Please try blow VBA code to Convert Excel file in PDF. Change path as per ur conviniece.. See attached sheet *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query *i don't want to use any other converter software or online website.* ** awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http
Re: $$Excel-Macros$$ xls to Pdf in VBA
dear Noorain Ansari (Assalamulaikum) as per your tryit.xls its not working. plz give me detail. with advance Happy Eid Mubarak to all. sajid memon On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sajid, As per your requirement Please try blow VBA code to Convert Excel file in PDF. Change path as per ur conviniece.. See attached sheet *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query *i don't want to use any other converter software or online website.* ** awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ xls to Pdf in VBA
Dear KBJ, W/S... That converter is working fine on my system.. press alt+F11 and Paste it code in Module and Press F5. I hope it will work fine.. Sub exltopdf_converter() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1) ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False end Sub On Mon, Aug 29, 2011 at 3:35 PM, Advocate kbj msma@gmail.com wrote: dear Noorain Ansari (Assalamulaikum) as per your tryit.xls its not working. plz give me detail. with advance Happy Eid Mubarak to all. sajid memon On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sajid, As per your requirement Please try blow VBA code to Convert Excel file in PDF. Change path as per ur conviniece.. See attached sheet *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query *i don't want to use any other converter software or online website.* ** awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ xls to Pdf in VBA
Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query i don't want to use any other converter software or online website. awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ xls to Pdf in VBA
See the Below Link .. http://www.mrexcel.com/forum/showthread.php?t=379973 http://www.pcreview.co.uk/forums/convert-excel-pdf-via-vbulletin-code-t95734 4.html http://www.giveawayoftheday.com/vba+code+convert+to+pdf/ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SAJID MEMON Sent: Saturday, August 27, 2011 4:29 PM To: Excel Group Subject: $$Excel-Macros$$ xls to Pdf in VBA Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query i don't want to use any other converter software or online website. awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ xls to Pdf in VBA
Hi friend, Pls try this website http://www.ipdfconverter.com/ Regards Rajesh A TCS Chennai On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query *i don't want to use any other converter software or online website.* ** awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ xls to Pdf in VBA
Hi Sajid, Just install the below PDF Printer Driver and use code for Printing... http://www.bullzip.com/products/pdf/info.php *Best Regards,* *Venkat * *Chennai* On Sat, Aug 27, 2011 at 3:58 AM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query *i don't want to use any other converter software or online website.* ** awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel