Another Multiple Text to Excel 2003 Question

mwinn

New Member
Joined
Dec 7, 2005
Messages
2
Our phone system records a text file along with a .WAV file of all our phone calls, the text file is a simple one line record that indicates the date, time filename of the associated .WAV file, the originating number, the destination number and some other supurfulous info. My boss wants me to put all of the text files into one worksheet. The problem is that there are about 10,000 text files right now, so doing it manually is impossible. Can you help me with a way to import multiple text files into one spreadsheet autoamtically? I can send you a few text files as examples if you give me an email address, since I can't see a place to attach the files here.


Thanks,
M. Winn
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Welcome to the board.
  1. How far have you gotten in this process on your own thus far?
  2. How skilled are you at VBA?
    • What's VBA?
    • I can record simple macros.
    • I can edit simple macros
    • I have written macros from scratch.
    • I know how to create userforms and program controls on them.
    • I have created class modules.
  3. Do the files follow a naming protocol?
  4. Are the files located in one directory or many?<ul>
  5. If more than one directory, is there a naming protocol for the directories?
[/list]There are many other questions to cover between where you appear to be now and where you want to get. We'll be glad to guide you as best we can, but we cannot walk for you. You'll need to take the steps and report your progress. And even so, the type of request you are making requires a fair amount of work to put together. You may want to contact Mr Excel for a quote if you do not have the know-how to do this within the timeframe your boss wants.
 
Upvote 0
Hi Greg,

Thanks for the quick response.

I know that I can import one file at a time, I haven't tried to write any macro's.

I know a little about VBA I know a lot more about the old microsoft basic

i'm sure I can edit an existing VBA macro, I haven't tried to write on from scratch but I am certainly willing to try, I just don't have a list of VBA terms, I may be able to obtain one though.

The file naming is 8 numeric digits, not necesarily in sequence, followed by .txt

Each phone extension has its own folder where the files are located, I would import each folder into its own spreadsheet, I.E. 1 spreadsheet for each extension containg all of the text files for that extension.

would you like to see one of the files?


thanks,

M. Winn
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,148
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top