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?
