خرید بک لینک

Vote count: 0

I have a macro enable workbook in my local folder. This workbook consists of 7 worksheet in total. Last sheet named as "AnsSheet". I want to save the last sheet (AnsSheet only) in the same folder location with modified name. Here is the code I am using which is not giving desired result.

Could you please guide. Thanks in advance.

Sheets("AnsSheet").Select
   Set wb = Workbooks.Add
   ThisWorkbook.Sheets("AnsSheet").Copy Before:=wb.Sheets(1)
   ActiveSheet.SaveAs Filename:=ActiveWorkbook.Path & "WF_Macro_" & Format(Date, "DD-MMM-YYYY") & ".xls"

asked 47 secs ago

برچسب: how to save single page of pdf,how to save single sheet in excel,how to save single page of pdf adobe acrobat,how to save single quote in sql server,how to save single sheet in excel 2010,how to save single page in word,how to save single page of pdf mac,how to save single slide from powerpoint,how to save single page pdf in indesign,how to save single quote in mysql, نویسنده: استخدام کار تاريخ: شنبه 27 شهريور 1395 ساعت: 6:38

صفحه بندی