We help IT Professionals succeed at work.

copy a template xlsx file based on data in other txt files using Batch program

Adam Ehrenworth
on
113 Views
Last Modified: 2017-04-17
I am trying to determine a way to create batch program that will look at the values (row by row) in a txt file and make copies of a template Excel file (let's call it template.xls) into another folder (one or each row with the name of the value in that row).

So if the txt file said:
abc
xyz
qqq

3 copies of the template excel file would end up in folder "reports"

abc.xlsx
xyz.xlsx
qqq.xlsx

What would that code look like?

Thanks

Adam
Comment
Watch Question

End-user support
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.