Solved

vba open a text file into excel

Posted on 2006-07-04
2
223 Views
Last Modified: 2011-09-20
Hi,
    I have a text data file with fields separated by fixed widths. How do I use Workbooks.opentext to open it as Excel having all fields copied over ? Let's say the widths are 5 8 8 5. Thanks for helping.
0
Comment
Question by:azcalv408
2 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 200 total points
ID: 17039464
Unfortunatley it is not very easy; I would reccomend that you read it in a line at a time and dump the contents into the workbook yourself

however

http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov05/hey1117.mspx

Contains all the details on what is expected to do it
0
 
LVL 8

Assisted Solution

by:kaliyugkaarjun
kaliyugkaarjun earned 200 total points
ID: 17042049
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now