Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

vba open a text file into excel

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
azcalv408
Asked:
azcalv408
2 Solutions
 
Raynard7Commented:
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
 
kaliyugkaarjunCommented:
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now