Converting directory of text files to Excel files

D

Drgerst

New Member
Joined
Mar 9, 2011
Messages
1
Hi, Would you please help me fix my macro? I'm using 97 Excel with Vista Windows. I am attempting to convert a directory of text files to Excel files formatted in a certain fashion. It is stopping after I open the first text file. Do yo uhave any suggestions? Thanks.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
Z

z168

Board Regular
Joined
Nov 4, 2009
Messages
165
I'll piggyback on your problem. Im in the same boat too

Although on mine I can get the data in excel BUT in a long string of text which doesnt help either.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Ottsel
  • Solved
Create File Directory Within Excel
Replies
3
Views
151
Eric W
Eric W
G
  • Solved
VBA - Text File Importer Always Brings Through the First File in the Directory
Replies
2
Views
80
ghost5
G
C
  • Question
The file format and extension don't match. Vba
Replies
1
Views
38
Cervani
C
P
  • Question
Merging Text Files with Excel VBA
Replies
3
Views
325
HaHoBe
HaHoBe
C
  • Solved
VBA Convert excel document to text file
Replies
3
Views
803
Trebor76
T

Forum statistics

Threads
1,191,718
Messages
5,988,271
Members
440,146
Latest member
rgomes8

Share this page

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
Top