hi all...can anybody assist please
i need to copy and paste from current workbook"aimssubtotal"all info on sheet1-2 and 3 create a new workbookcopy info into this workbook from "current "aimssubtotal" then save new workbook and name as current date example 10/07/2006.xls and then close current workbook"aimssubtotal" without saving and close the new file into specific directory which will be
S:\DDC Admin\CASH ADMINISTRATION\Coupons\2006
which will be saved . the first workbook however will not be saved(ie where my macro is)
if anybody can help would be much appreciated
thx
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!