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
@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
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
10 matches
Mail list logo