Oct 23, 2007 #1 cboz Technical User Dec 24, 2002 42 US I want to replace MyName with the tab name of the active sheet in the following code. How is this done? ActiveWorkbook.SaveAs "G:\Procurement\CXB\07 Vendor forecasts\" & MyName & Format(Date + 3, "yymmdd") & ".xls
I want to replace MyName with the tab name of the active sheet in the following code. How is this done? ActiveWorkbook.SaveAs "G:\Procurement\CXB\07 Vendor forecasts\" & MyName & Format(Date + 3, "yymmdd") & ".xls
Oct 23, 2007 #2 S SkipVought Programmer Dec 4, 2001 47,492 US Hi, Code: ActiveWorkbook.SaveAs "G:\Procurement\CXB\07 Vendor forecasts\" & activesheet.name & Format(Date + 3, "yymmdd") & ".xls" Skip, When a diminutive clarvoyant had disappeared from detention, headlines read... Small Medium at Large Upvote 0 Downvote
Hi, Code: ActiveWorkbook.SaveAs "G:\Procurement\CXB\07 Vendor forecasts\" & activesheet.name & Format(Date + 3, "yymmdd") & ".xls" Skip, When a diminutive clarvoyant had disappeared from detention, headlines read... Small Medium at Large