So I have a macro here that will copy some information from a spreadsheet to an access database.
I want to change it so it is its own file, and when run the user is asked what spreadsheet they want to export to the database.
I will need to include the "Microsoft DAO 3.6 Object Library" (currently I have it checked off under references)

I have installed Microsoft visual basic 2008 express, and pasted my code in there but there are lots of "undeclared" office functions / objects like:
Application
Excel
ActiveWorkbook
Database
OpenDatabase
dbOpenTable
Range
Worksheet

what would I need to import to get access to these things?