$$Excel-Macros$$ Acitive Workbook Name

Dear Friends, Please advise the coding for save as Acitive workbook has worksheet name. E.g. If worksheet name is Holding_002 then the file should be save as Holding_002. Regds Shree -- -- Some important links for

Re: $$Excel-Macros$$ Acitive Workbook Name

Goto the sheet Holding_002 and use the following Code. it will save the ActiveWorkbook with activeSheet name at Defaut save location.. activeworkbook.saveas activeSheet.name On Tue, Jul 12, 2011 at 8:18 PM, SHREE chidurala.sh...@gmail.com wrote: Dear Friends, Please advise the coding for save

Re: $$Excel-Macros$$ Acitive Workbook Name

Thanks Rajan Sir for quick reply in just 3 mins. Regds Shree On Jul 12, 7:51 pm, rajan verma rajanverma1...@gmail.com wrote: Goto the sheet Holding_002 and use the following Code. it will save the ActiveWorkbook with activeSheet name at Defaut save location.. activeworkbook.saveas