There are several methods that you could use.
Here is one example:-

Paste the following code into a standard module

Option Explicit
Sub ImportRawData()

Dim sRawDataFilename As String
sRawDataFilename = Application.GetOpenFilename()

' user hit cancel
If sRawDataFilename = "False" Then Exit Sub

Workbooks.OpenText sRawDataFilename, _
DataType:=xlDelimited, _
semicolon:=True


End Sub


TIP: If you're new to VBA, try turning on the Macro
recorder ( under Tools/Macro), open the text file
manually, stop the recorder and then examine your code.
The code thus produced will give you a good idea of how
your own code might look.


Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
dear all,
firstly i'd like to introduce my self, i'm dwi
(pronounced like do we)
from indonesia, i use excel in daily work, but not vba,
right now i'm working with table data as i show you in
attachment file

can somebody help me, how to convert this array text to
rowed data in
excel, example of how i wanted to be showed in the
attachment file

huge thanks
regard
dwi

Attachment filename:
031217.zip
Download attachment:
http://www.excelforum.com/attachment.php?postid=395162
---
Message posted from http://www.ExcelForum.com/

.