Re: $$Excel-Macros$$ save active sheet in new workbook

2014-09-11 Thread Paul Schreiner
In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Anil Gawli >To: "excel-macros@googlegroups.com" ; Rupesh >Patil >Sent: Thursday, S

Re: $$Excel-Macros$$ save active sheet in new workbook

2014-09-11 Thread Anil Gawli
Dear Rupesh, Write below code in a module. Dim b As String ActiveSheet.Name = b Activesheet.SaveAs Filename:="C:\HarshadMacro\" & b & ".xlsx" Workbooks(b & ".xlsx").Close On Thu, Sep 11, 2014 at 12:05 PM, Rupesh Patil wrote: > Hello Expert, > > I need your help. > I need VBA Macro. > How to s

$$Excel-Macros$$ save active sheet in new workbook

2014-09-10 Thread Rupesh Patil
Hello Expert, I need your help. I need VBA Macro. How to save active sheet to new workbook with same sheet name in specific location. -- Thanks & Regards, Rupesh Patil, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook p