How do i create a macro that saves the filename that is equal to a cell in the sheet?
C Chukka Dec 6, 2005 #1 How do i create a macro that saves the filename that is equal to a cell in the sheet?
D Dave Peterson Dec 6, 2005 #2 with activeworkbook .saveas filename:="C:\myfolder\" & .worksheets("sheet99").range("z99").value _ & ".xls", fileformat:=xlworkbooknormal end with No checking at all!
with activeworkbook .saveas filename:="C:\myfolder\" & .worksheets("sheet99").range("z99").value _ & ".xls", fileformat:=xlworkbooknormal end with No checking at all!
