hi
my present code is set for the end of the month
i need to update to filter and export on demand
current : DateStart = Application.WorksheetFunction.EoMonth(NextPromptDate, -2) + 1 how do I change to be the first of the month of the date I am exporting?
current: DateEnd = Application.WorksheetFunction.EoMonth(NextPromptDate, -1) how do i chnage to be end of the month of the date i am exporting?
current: ReportMonth = Application.WorksheetFunction.EoMonth(NextPromptDate, -2) + 1 how do i change to be the month and year of the date i am exporting?
once i can update my parameters then my filters will work
thanks
my present code is set for the end of the month
i need to update to filter and export on demand
current : DateStart = Application.WorksheetFunction.EoMonth(NextPromptDate, -2) + 1 how do I change to be the first of the month of the date I am exporting?
current: DateEnd = Application.WorksheetFunction.EoMonth(NextPromptDate, -1) how do i chnage to be end of the month of the date i am exporting?
current: ReportMonth = Application.WorksheetFunction.EoMonth(NextPromptDate, -2) + 1 how do i change to be the month and year of the date i am exporting?
once i can update my parameters then my filters will work
thanks