| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open for input vba help
I have a function that uses the following code:
Open "filename.csv" For Input As #1 Line Input #1, NRPI For I = 1 To NRPI Line Input #1, t$ Next I For J = 1 To FNPI Input #1, MWI, NPI, QS$, AA, BB X1$ = QS$ For I = 1 To NPI Input #1, TY, CH, MH, KH, DA If (FNPI - J) 0.2 Then GoTo 10 TPI(I) = TY + 459.67: CPI(I) = CH: MUI(I) = MH: KI(I) = KH: RHOI(I) = DA 10 Next I Next J Close #1 What I want to do is move the csv file to a sheet inside the excel file. How would I go about doing this, and having it work through the "lines" of the worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| How can I have an input form to add a random no. to each input entry? | Excel Discussion (Misc queries) | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| Password box to remain open after wrong input | Excel Discussion (Misc queries) | |||
| =SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
Linear Mode
