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

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.SaveAs

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

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) - Cells(2,

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

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. Dim

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

You may click.. https://groups.google.com/groups/opt_out Thanks On 5 Jul 2013 10:51, R Swarup ramswarup...@gmail.com 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