I need help in building an excel macro where the template file and report file are in specific locations.
The template file should get data populated from the report file per specifications and then save the output as testreport_20120911_14:00:
00.xls (2003-2007 format, todays date and saved time)
Also if there is any cell in the report file with comma separator, the template should take it in as new line with the cell.
Attached are the two example files.