Good morning.
I have some .txt files (for example cat_jack_13-10-14.txt , cat_jack_20-10-14 , dog_jack_20-10-14) in the folder C:\Users\M\Desktop\Jack.
These files are in this format: animal_person_date.txt (or .cvs)
I want a small program that:
1) brings one of these .txt file (so there is a button "Load" and I decide what file of the folder)
2) imports the chosen file in the second sheet of a excel document that I have created before (so in the second sheet I have raw data and in the first sheet an interface that brings data from the second sheet)
Then, when I will have got about ten .txt files that begin with "cat" I want a program that:
1) brings all files beginning with "cat" in the folder Jack
2) copy them in a second sheet of an excel file.
Is it possible? Or are there softwares that do these things?
Thank you for your support.
Program that automatically brings txt file in excel
Moderator: DosItHelp
Re: Program that automatically brings txt file in excel
Sounds like something that is easily done in vb script. I don't know of a way to do all of this via batch.
-
- Expert
- Posts: 1166
- Joined: 06 Sep 2013 21:28
- Location: Virginia, United States
Re: Program that automatically brings txt file in excel
Yeah, this has VBA macro written all over it.