Turn Excel Macro to Standalone App/script

[dethredic]

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?

[gunsmokingman]

I dont know if this is what you want

1:\ In Microsoft visual basic 2008 express toolbar open the Project

2:\ From The Project ToolBar Select Add Reference

This will open a dialog where you can add various objects to your project,

from this dialog.