RE: $$Excel-Macros$$ Macro to Print the sheet in PDF and save in a folder.

2012-04-09 Thread Rajan_Verma
and save in a folder. Sorry, Big file is not reaching to group. -- Forwarded message -- From: Excel_Lover Date: Mon, Apr 9, 2012 at 4:52 PM Subject: Re: $$Excel-Macros$$ Macro to Print the sheet in PDF and save in a folder. To: excel-macros@googlegroups.com Version is excel

RE: $$Excel-Macros$$ Macro to Print the sheet in PDF and save in a folder.

2012-04-09 Thread Rajan_Verma
End If Next MsgBox intI & " Worksheet(s) has been Exported to PDF", vbInformation End Sub http://excelpoweruser.blogspot.in Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Apr/Mon/2012 05:22 To: excel-macros@goog

Re: $$Excel-Macros$$ Macro to Print the sheet in PDF and save in a folder.

2012-04-09 Thread Excel_Lover
> wksSheet.Visible = xlSheetHidden > > blnFlag = False > > End If > > End If > > Next > > MsgBox intI & " Worksheet(s) has been Exported to PDF", vbInformation* > *** > > &g

RE: $$Excel-Macros$$ Macro to Print the sheet in PDF and save in a folder.

2012-04-09 Thread Rajan_Verma
l_Lover Sent: Apr/Mon/2012 05:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to Print the sheet in PDF and save in a folder. Dear All, Hope somebody can help me to create a macro to: print the sheet in pdf, name the PDF as cell value 'E4'

Re: $$Excel-Macros$$ Macro to Print the sheet in PDF and save in a folder.

2012-04-09 Thread Excel_Lover
Dear All, Hope somebody can help me to create a macro to: print the sheet in pdf, name the PDF as cell value 'E4' and save the same into location : C:\Users\FAISAL\Desktop\PRSD Please find the attached sheet for your reference. Thanks in advance for your valuable assistance. On S