Subscript out of range

[rflorentino]

Now I don't know what's causing this. Kindly help me out guys please..Everytime I run the code it pops an error saying Subscription out of range.

Thank you in advance guys.

Please Login or Register  to view this content.

[shg]

Sounds like not all of the lines have five commas.

[rflorentino]

Yup. Some lines let's say have less than 5 data while some have only 2 or 3. Can you give me an advice with regards to this.

Thanks.

[HaHoBe]

Hi, rflorentino,

IŽd go away from using ActiveCell for code ASAP. Maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

[:) Sixthsense :)]

Check this...

Please Login or Register  to view this content.

[rflorentino]

Hi to both of you and thank you for helping me. It turned out real good. Now for the next problem probably related to this one so I decided not to open another topic since it has something to do with this topic.

Now that I can transfer all file from .csv file to my excel here's another problem.

Here's the scenario

1. If book 1 (.cs)is like this

name	age	gender	phone	bday
John	12	male	989101011	dec 15 1984
Mary	15	female	010998481	april 9 1960
Robert	22	male	12345678	July 22, 1978

and my excel is like this

age	bday	name	gender	phone

Same code I have given before...How will I transfer file if my book has constant headers such as seen above. I'm totally out of idea how to start this one. Please help.

[HaHoBe]

Hi, rflorentino,

why do the files differ from your workbook (or put another way: will there be more different ways of receiving the information)? From what I spot you could alter the design of your workbook or use a loop to transfer the data while searching for the headers and then copying info.

Ciao,
Holger

[rflorentino]

Hi, rflorentino,

why do the files differ from your workbook (or put another way: will there be more different ways of receiving the information)? From what I spot you could alter the design of your workbook or use a loop to transfer the data while searching for the headers and then copying info.

Ciao,
Holger

Hi Good Sir,

Thanks once again for the solution before that you gave me. It really worked out a you have stated. With regards to my last post, Yes there are more different ways of receiver the information. So now, I do not know exactly how to formulate a code for this as I'm more comfortable working in asp. and this is my first project for myself as a newbie developer for VBA .

Can you give me sir an example on how to get this done? Cheers and once again thanks for the answer.

[HaHoBe]

Hi, rflorentino,

I doubt that you would expect the find the solution to your follow-up question if you google "subscript out of range" and recommend to start a new thread on that subject with two sample workbooks, one holding the macro, one holding some sample data for checking out the code.

Ciao,
Holger