Solved How to create batch script to create text files from excel

Dell Inspiron 15r moon silver 15.6" note...
September 9, 2014 at 15:10:17
Specs: Windows 7, 2.67 ghz 4GB Ram
I'm new to scripting and have been struggling for several days trying to put this together. I could really use any help you can provide. Thank you!

I have an excel spreadsheet that I need to use to create different text files using cell data in the spreadsheet. I need the script to create a text file for each line in the spreadsheet and continue until there is no further entries. The name of the text file will be numbers entered in the first line using cell 1 & 2 to create the name. Then insert lines in the text file itself based on other entries in the next cells on line one. For example it will take cell 3, 4 and 5 and write them to the same text file and save it using the name created from cells 1 & 2. It should then move on to the next line and create another text file using the same cells in line 2 and so on. This maybe a simple script for most of you but I have really been struggling probably making it a lot harder then it needs to be. Any help would be greatly appreciated.

See More: How to create batch script to create text files from excel

Report •

September 10, 2014 at 09:52:14
✔ Best Answer
To all the followers of the Forum, I sent a private message to the OP to establish a direct link to him by e-mail since the script I have in my repository solves the problem but it is quite complex. If all goes good, I shall post my solution to make it public.

To ITripleDogDareYou, check your inbox.

Report •
Related Solutions

Ask Question