You'll find that there are a number of code samples already posted on the forum. Try searching for "dim" and "object" in one search, or specific methods like SetReportFile, SetModelFile, or JetExportTable.
Nick Osdale-Popa has often posted great programming solutions. Occasionally I get one right. Of course there've been many others who have contributed as well.
If you get stuck on something or other, post your problem and we'll all do our best to assist.
Since you're in Florida, you may want to attend the User Conference next month. One of the scheduled guest presentations will be a session on Automating Monarch.