VBA - How to put data in cell with macro?

[indieFan]

I’m a complete novice when it comes to VBA. (I’m currently without anything to do at work, so I’m trying to write a program.)

I’m trying to write a macro code in VBA to open a bunch of files and calculate how many lines are in the file. I then want to write the total number of lines in the cell of the column of a “blank” file. When I’ve tried to use the line

cells(k,1) = total

I get an “object” error. Can anyone help me?

Thanks,
indieFan

[Ed_Law]

I’m a complete novice when it comes to VBA. (I’m currently without anything to do at work, so I’m trying to write a program.)

I’m trying to write a macro code in VBA to open a bunch of files and calculate how many lines are in the file. I then want to write the total number of lines in the cell of the column of a “blank” file. When I’ve tried to use the line

cells(k,1) = total

I get an “object” error. Can anyone help me?

Thanks,
indieFan

It is not nice that nobody is answering your question, maybe because it has nothing to do with robotics. I am only an intermediate Excel user but you will have better luck asking the question on another forum. That is where I learn all my VBA stuff. The website is www.mrexcel.com. They have over 1.6 million posts there about Excel and VBA. Good luck.

Ed