kris_sk2012
asked on
Excel 2010 macro
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.
Template.xlsx
Report.xlsx
The template file should get data populated from the report file per specifications and then save the output as testreport_20120911_14:00:
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.
Template.xlsx
Report.xlsx
ASKER
Let's say that they both are in one directory for now. But I need an option to specify a full path once I know where they will be. So the template macro will go find for the report file in that path. And since there will be multiple files, we need the latest report file.
Regarding comma separator, this applies to only one column and where that is true, the comma would be replaced by a new line so they are readable in new line format.
Regarding comma separator, this applies to only one column and where that is true, the comma would be replaced by a new line so they are readable in new line format.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
For now let's say the file will be report.xls or report.xlsx
Only one file exists. Also the directory path is constant.
Only one file exists. Also the directory path is constant.
Regarding the comma separator, do you mean you want it to be replaced with a new line character to create a multi-line cell?