I've been doing searches for awhile, and getting mostly examples like this one:
http://www.exceltip.com/st/Use_a_clo...Excel/432.html
I'm not good with SQL and was hoping to find something simple so I could finish what I'm doing quickly.

I need to connect to a workbook/sheet without opening it and find the last used row(If Cell(1,1) is empty, it will be a blank row). Then on the next row down I need to copy some text into a few columns worth of cells.

If I have to use SQL, I guess I could use some pointers. I learned a tiny bit of it once to get through another project but it gave me a headache and I stink at it

Oh and I'm actually using 97-VBA if that limits me at all.

Thanks