I have an excel sheet which has data of the employee leave applications.
This sheet gets data from a userform which is filled by an employee.
The data then gets stored in the excel sheet for the review of manager.
What i want to do is that as soon as an entry is created it should generate a report of that particular leave application which contains all the details of the leave and save it in an html format.
Also once the manager reviews the leave application he writes comments in the application which should again get updated automatically in the html file.
I want to convert to html with a specific filename so that the file can be uploaded to my webserver and can be accessed by us anywhere and at anytime!
I have attached a copy of my excel sheet which has the data of leave applications.
Bookmarks