Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import array text to row data in excel
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
import array text to row data in excel
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
import array text to row data in excel
dear all...,
dear mr patric, thanks for the tips, the macro recorder is new things for me, i can us it in many of my importing process ;) but for my need in importing source datas as i attached (RTE....txt) t excel format it's not easy for me, because as you see the source i dynamic i'd like to use loop-things so my process go maybe like this .. read line: if belong to RTE=100 -- write RTE=100, write all the array data to ro data in excel: for the ASP, ATTEMPT....(until) TRAFFIC if still the datas belong to RTE=100 -- write RTE=100, write all th array datas again, if RTE <100, RTE=XXX -- write RTE=XXX, write all the array data belong to RTE=XXX and so on like that until the datas is fineshed sorry, i'm just an amateur in vba, but if i can see, sample coding believe i can modify it thanks for ur kind dw -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I import data from a text file into Excel 2003 | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
import text and sort data into excel | Excel Worksheet Functions | |||
import text and sort data into excel | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |