Re: $$Excel-Macros$$ Convert Excel Ranges to PDF
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-A2E79ED87041displaylang=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
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-A2E79ED87041displaylang=en 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
Re: $$Excel-Macros$$ Convert Excel Ranges to 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 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 range only. Thanks Regards, Anil Bhange IP - 512320 -- -- 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 save as PDF.GIF
Re: $$Excel-Macros$$ Convert Excel Ranges to PDF
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. 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 range only. Thanks Regards, Anil Bhange IP - 512320 -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- 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
$$Excel-Macros$$ Convert Excel Ranges to PDF
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 range only. Thanks Regards, Anil Bhange IP - 512320 -- -- 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