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
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
>> 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
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...
>
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
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
>
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
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
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
