Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with loop to import data
I need some help with importing data on excel (.csv format). This is briefly what i've done: Dim Share(1 to 6) as string Dim j as integer House(1) = ABC House(2) = DEF House(3) = GHI House(4) = JKL House(5) = MNO House(6) = PQR For j = 1 To 6 Step 1 ActiveWorkbook.Worksheets.Add With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:\Excel\"House(j)".csv" _ , Destination:=Range("A1")) ... .. .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with loop to import data
Oops, a typo here... In the 3rd line, it should read: Dim *House*(1 to 6) as string instead of Dim Share(1 to 6) as string Thank -- silves ----------------------------------------------------------------------- silvest's Profile: http://www.excelforum.com/member.php...fo&userid=1466 View this thread: http://www.excelforum.com/showthread.php?threadid=26283 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Loop QUESTION to end of data range... | Excel Worksheet Functions | |||
Loop QUESTION to end of data range... | Excel Worksheet Functions | |||
Checking data with a loop | Excel Programming |