Re: $$Excel-Macros$$ excell to pdf

2012-02-02 Thread PrIyAnKa
*Subject:* Re: $$Excel-Macros$$ excell to pdf ** ** Hi Rajan, ** ** Problem resolved. ** ** Excellent job to help us on this article. ** ** Regards, Kaushik -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ excell to pdf

2012-02-02 Thread chandra sekaran
to PDF, vbInformation End Sub ** ** Rajan ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *KAUSHIK SAVLA *Sent:* Jan/Tue/2012 08:28 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ excell

RE: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread Rajan_Verma
Try this: Sub CreatePDF() Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True,

Re: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread chandra sekaran
hi Rajan, lot of thanks it is working fine Regards chandru On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this: ** ** Sub CreatePDF() ** ** Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets

Re: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread KAUSHIK SAVLA
Hi Chandra, It is not working in my system Cold you please what you did to get it worked properly? Regards, Kaushik -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread raghu gr
hi, its not working to me also, error in line fixed width is comming with regards raghu On Tue, Jan 31, 2012 at 7:13 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Chandra, It is not working in my system Cold you please what you did to get it worked properly? Regards, Kaushik --

RE: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread Rajan_Verma
Which version of excel are u using?? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of raghu gr Sent: Jan/Tue/2012 07:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excell to pdf hi, its not working to me also, error

Re: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread KAUSHIK SAVLA
Hi Rajan, I am using excel 2007 version. Regards, Kaushik -- FORUM RULES (986+ 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

RE: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread Rajan_Verma
-Macros$$ excell to pdf Hi Rajan, I am using excel 2007 version. Regards, Kaushik -- FORUM RULES (986+ 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

RE: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread Rajan_Verma
= intI + 1 End If Next From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Jan/Tue/2012 08:10 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excell to pdf Hi Rajan, Please find attached file I am using

Re: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread KAUSHIK SAVLA
Hi Rajan, Problem resolved. Excellent job to help us on this article. Regards, Kaushik -- FORUM RULES (986+ 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

RE: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread Rajan_Verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Jan/Tue/2012 08:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excell to pdf Hi Rajan, Problem resolved. Excellent job to help us on this article

Re: $$Excel-Macros$$ excell to pdf

2012-01-31 Thread PrIyAnKa
** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *KAUSHIK SAVLA *Sent:* Jan/Tue/2012 08:28 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ excell to pdf ** ** Hi Rajan, ** ** Problem resolved