Hi Golden Lance,
its amazing. i didnt know we can work like this also. thanks a lot for your
input.
- Original Message
> From: GoldenLance
> To: MS EXCEL AND VBA MACROS
> Sent: Sat, 30 April, 2011 9:14:51 AM
> Subject: Re: $$Excel-Macros$$ Convert Excel Ranges to PDF
&
Hanumant,
Download the COM Add-in from
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en
and install. You should now be able to convert the range to PDF using
the vba
ActiveSheet.UsedRange.ExportAsFixedFormat Type:=xlTypePDF,
Download DoPDF from Internet.. Select the Range and Print seletion by this
doPDF Printer...
On Thu, Apr 28, 2011 at 6:09 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi Expert,
>
>
>
> I am having one excel file which contains many report, I wanted to convert
> the same in PDF
Save As *.PDF (excel 2007)
[image: save as PDF.GIF]
On Thu, Apr 28, 2011 at 7:39 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi Expert,
>
>
>
> I am having one excel file which contains many report, I wanted to convert
> the same in PDF. Below example will give you further d
Hi Expert,
I am having one excel file which contains many report, I wanted to convert the
same in PDF. Below example will give you further details,
Sheet 1 : from A2 : K30
Sheet 2 : from A2 : K 45
Sheet 4 : from B5 : H14
Worksheet also has other details but I wanted to convert those specific ra
