Guys

after spending grueling 3 days with this issue I found the solution
myself. And I found it a minute after posting the question here..

This is the only change I had to do...asp was running the macro but it
wasn't saving the changes in excel. so for wb.close(), i gave 'save'
argument as true and it worked.

wb.Close(true, Missing.Value, Missing.Value);

i see many postings on web for this problem with no solution. here is
the solution.

have fun.