Re: $$Excel-Macros$$ Re: SAVE As file name

2013-07-04 Thread vba
You may click.. https://groups.google.com/groups/opt_out Thanks On 5 Jul 2013 10:51, "R Swarup" wrote: > pl tell how to exit out of this group? > > > On Fri, Jul 5, 2013 at 10:28 AM, sandeep shivpujan singh < > mandy07s...@gmail.com> wrote: > >> Hi, >> >> You can use below code also. I think yo

Re: $$Excel-Macros$$ Re: SAVE As file name

2013-07-04 Thread R Swarup
pl tell how to exit out of this group? On Fri, Jul 5, 2013 at 10:28 AM, sandeep shivpujan singh < mandy07s...@gmail.com> wrote: > Hi, > > You can use below code also. I think you want to save a blank sheet with > the required name. > > 1. Code to save one sheet with the data given in cells 2. >

$$Excel-Macros$$ Re: SAVE As file name

2013-07-04 Thread sandeep shivpujan singh
Hi, You can use below code also. I think you want to save a blank sheet with the required name. 1. Code to save one sheet with the data given in cells 2. Dim strPath As String strPath = ActiveWorkbook.Path & "\" ActiveSheet.Copy ActiveWorkbook.SaveAs Filename:=strPath & Cells(2, 1) & "-" & Cel

$$Excel-Macros$$ Re: SAVE As file name

2013-07-04 Thread Vabz
Hi You can try this code: Sub SaveFileAs() Dim FName As String Dim FPath As String FPath = ThisWorkbook.Path '"C:" FName = ABC(Range("A2").Value, Range("B2").Value, Range("C2").Value) 'FName = Sheets("Sheet1").Range("A1").Text ThisWorkbook.S