HELP! Running VBA Procedures from EXcel

[benjy5]

Hey everyone,
I'm coding VBA in Excel 97 and I"m trying to run a specific procedure in a module in Access 97. However, I can't seem to code this properly. I"m trying to use the DAO library and Access libraries but they don't seem to work.
Does anyone have any suggestions??

Thanks in advance!!