| || |
update excel cell with weekdays only
I have excel sheet that i need to send every Thursday before 4 pm to a email, but i need to update the date coloumn with next 5 weekdays(working days), starting from following monday
Current Value in excel (Coloumn C, row 2 to 6)
on 6/12/2014,the VBscript should automatically update the excel with following week days(following monday), this should happen every thursday before 4PM and sent email with attachment with the updated excel
below Coloumns are in excel
Sr no-------Project ID-------Work Date-------Employee Name-------Emp Id-------Log In Time
This sounds more like excel function/macro work than anything to do with QTP.
Create a List of Business Days in Excel » Bacon Bits
Maybe you can get the day of the week for the next 7 days. Throw out the ones that are Sat and Sun. I'm not sure how to know if it is a holiday.
The link I gave showed how to use the WORKDAY function in excel.
Sorry...I was in a rush. I gave my input without reading the link you supplied.