I am relatively new with working with Office from inside VB, and have never done this before, so would like some tips.

I have VB6 and Office 97. What I want is to know how to do basic stuff to an Excel sheet from inside a VB program, such as:

open an existing workbook
Find/Go to a particular worksheet inside that workbook
Find the last row in use on that sheet
Find the contents of a cell in that row
Copy a formula from one cell to another, so that the formula in the new cell has references to the new row it sits in
Write values from variables into cells on the sheet
How to get the current date and put it into a cell
How to set the format of a cell or range of cells

What I'm doing is trying to write a program that will update a bunch of workbooks/sheets from inside one program, rather than my opening each sheet or book and manually typing in changes.