a) Create a VBA macro which will do following:
1) Delete all the drawings from a workbook.
2) Collect some data from a worksheet ("Sheet1") and format them and put them in another worksheet ("Sheet2") in specific order
b) Create another macro which will save the data in "Sheet2" populated by the previous macro as HTML documents. Each row of Sheet2 should be saved as a seperate HTML file.