Posts by KYUNW00

Re: Input Function

yes, the first two

Re: Input Function

thats corret

So i try to input an txt into a excel spreadsheet, how do skip to certain lines or number?
for example if the txt is like

1,2,3,4,5,6,7,8

and i want the excel sheet to start at the the third number

3
4
5
6
7
8

I need to input a txt into the excel.
the file is some number. It is five in row.
i need them go down to the spreadsheet in a column.

plx help

Re: Outputing A Text File

on the txt file the 0% is to be ignore

Re: Outputing A Text File

FS 1 6% 0% 0% 0% 0% 0% 0% 0%
FS 2 6% 6% 0% 0% 0% 0% 0% 0%
FS 3 6% 6% 5% 0% 0% 0% 0% 0%
FS 4 6% 6% 5% 4% 0% 0% 0% 0%
FS 5 6% 6% 5% 4% 3% 0% 0% 0%

Re: Outputing A Text File

macro. i kind of edited my post, for my job i was asked output a chart to a txt file

Re: Outputing A Text File

change part 1 to part 2

sigh

Re: A Write Statement With A For Loop

thanks a lot man:smile:

so I was ask to output a chart to a txt.file and i was require to do the following:

i did part 1 already, now i need to repart part 1 three times

Part 1

0,0,1,6
0,0,2,3

to
part 2

0,0,1,6
0,0,2,3
0,0,3,6
0,0,4,3
0,0,5,6
0,0,6,3

as you can see the third number had to go up to 6 mulitple of 3
and the forth number 6,3 as group had to repeat 3 times

this is difficult so i need help

thanks a lot

0
0
0
0
0
0
0

So here is my problem:

how do you repeat a write statement four time

form 1234 to 1234123412341234

:smile:

thanks a lot