Re: $$Excel-Macros$$ xls to Pdf in VBA error

2011-12-08 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ xls to Pdf in VBA error

2011-09-01 Thread Prabhu
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 ti

Re: $$Excel-Macros$$ xls to Pdf in VBA error

2011-08-30 Thread Venkat CV
>> 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: exce

Re: $$Excel-Macros$$ xls to Pdf in VBA error

2011-08-30 Thread NOORAIN ANSARI
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... >

Re: $$Excel-Macros$$ xls to Pdf in VBA

2011-08-29 Thread NOORAIN ANSARI
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.ExportAsFix

Re: $$Excel-Macros$$ xls to Pdf in VBA

2011-08-29 Thread Advocate kbj
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 wrote: > Dear Sajid, > > As per your requirement Please try blow VBA code to Convert Excel file in >

Re: $$Excel-Macros$$ xls to Pdf in VBA

2011-08-27 Thread Venkat CV
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 wrote: > Dear Experts, > > I want an active sheet with command button (EXCEL 2003) con

Re: $$Excel-Macros$$ xls to Pdf in VBA

2011-08-27 Thread rajesh a
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 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

RE: $$Excel-Macros$$ xls to Pdf in VBA

2011-08-27 Thread Rajan_Verma
@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

$$Excel-Macros$$ xls to Pdf in VBA

2011-08-27 Thread SAJID MEMON
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 con