Turn Excel Macro to Standalone App/script

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?

Welcome to the forums... :wave:

Microsoft Visual Basic 2008 was published after vb6. And it is commonly known as VB.Net. Which is different from the VBA(that's your case) and VB6...!

Quote:

---

Originally Posted by akhileshbc

Welcome to the forums... :wave:

Microsoft Visual Basic 2008 was published after vb6. And it is commonly known as VB.Net. Which is different from the VBA(that's your case) and VB6...!

---

So you are saying that I shouldn't be using Visual Basic 2008 or VB6? If that is the case what can I use?

If you have good knowledge in VBA, then you could do it in VB6....! But VB6 is out of date. VB.Net is the latest version that Microsoft is supporting. You could do it either in VB or VB.Net...!
If you are going with VB.Net then, you have to ask a mod to move this thread to the Vb.Net section of this forum. You have currently posted your question in Vb6 and earlier section. :)

Ok, thanks, will try that.

Moved To VB.NET