hello
I have files contain many sheets and each sheet contains data for 12 months .the data are a1:g and the column A contains date M/DD/YYYY . what I want macro to show inputbox and write the sheet after this should save all of the ranges for all the months separately not in one file . each month should be in one file for written sheet into inputbox as PDF , but when save for each month I would create the headers for each month which save as pdf . the headers in row1 , then when save for each month it should contain the headers .
the directory is D:\DATA , but when save in this directory should create folders and thier names based on sheets names and the files should save in sheet is relating of it
and if I run the macro repeatedly should pops up message " the files have already existed ,do you want replace them ? " if press ok then replace it , if press no then nothing happens .
thanks
I have files contain many sheets and each sheet contains data for 12 months .the data are a1:g and the column A contains date M/DD/YYYY . what I want macro to show inputbox and write the sheet after this should save all of the ranges for all the months separately not in one file . each month should be in one file for written sheet into inputbox as PDF , but when save for each month I would create the headers for each month which save as pdf . the headers in row1 , then when save for each month it should contain the headers .
the directory is D:\DATA , but when save in this directory should create folders and thier names based on sheets names and the files should save in sheet is relating of it
and if I run the macro repeatedly should pops up message " the files have already existed ,do you want replace them ? " if press ok then replace it , if press no then nothing happens .
thanks