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 <noorain.ans...@gmail.com>wrote: > Dear Sajid, > > As per your requirement Please try blow VBA code to Convert Excel file in > PDF. > > Change path as per ur conviniece.. > See attached sheet........ > > *Private Sub CommandButton1_Click() > Dim wrknm As String > wrknm = ActiveWorkbook.Name > wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)* > *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ > "C:\Documents and Settings\Administrator\Desktop\" & wrknm & ".pdf", > Quality:=xlQualityStandard, _ > IncludeDocProperties:=False, IgnorePrintAreas:=False, > OpenAfterPublish:= _ > False > End Sub > > * > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON <sajidwi...@hotmail.com>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 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 converter software or online website.* >> ** >> awaiting your positive responce >> >> sajid memon >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 > -- ---------------------------------------------------------------------------------- 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
