Program that automatically brings txt file in excel

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
assurdo
Posts: 2
Joined: 22 Sep 2014 07:13

Program that automatically brings txt file in excel

#1 Post by assurdo » 22 Sep 2014 07:15

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.

Samir
Posts: 384
Joined: 16 Jul 2013 12:00
Location: HSV
Contact:

Re: Program that automatically brings txt file in excel

#2 Post by Samir » 22 Sep 2014 15:48

Sounds like something that is easily done in vb script. I don't know of a way to do all of this via batch.

ShadowThief
Expert
Posts: 1166
Joined: 06 Sep 2013 21:28
Location: Virginia, United States

Re: Program that automatically brings txt file in excel

#3 Post by ShadowThief » 22 Sep 2014 18:36

Yeah, this has VBA macro written all over it.

Post Reply