Hi Golden Lance,

its amazing. i didnt know we can work like this also. thanks a lot for your 
input.



----- Original Message ----
> From: GoldenLance <samde...@gmail.com>
> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
> 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
>n
> 
> and  install. You should now be able to convert the range to PDF using
> the  vba
> 
>         ActiveSheet.UsedRange.ExportAsFixedFormat  Type:=xlTypePDF,
> Filename:= _
>              "C:\FullPath Of Folder\MyFile.pdf", Quality:= _
>              xlQualityStandard,  IncludeDocProperties:=True,
> IgnorePrintAreas:=False, _
>               OpenAfterPublish:=True
> 
> Cheers,
> 
> GL
> 
> -- 
>----------------------------------------------------------------------------------
>-
> Some  important links for excel users:
> 1. Follow us on TWITTER for tips tricks and  links : 
>http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email  to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> Like  our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
> 

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to