Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Opening an Access database using VBA in Excel
Thanks kim, I've got it working now. In case anyone else is interested in the code I've posted it below. Deco Dim strPath As String Dim objAccess As Object strPath = "G:\reinledg\Midnight\697LPC\LPCCashImport.mdb" Set objAccess = GetObject(strPath)- Deco1
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Opening an Access database using VBA in Excel
I writing a VBA procedure in Excel. Part of the function is to open an Access database in order to populate certain tables. I'm having problems opening the databse. Can any of you experts out there give me any help?? Cheers- Deco1
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Opening Database 2 from within Database1
I'm using VBA within Access. I've got a module in database 2 which runs when the database 2 is opened. When it has finished the database closes down. What I would like to be able to do is to open database 2 from database 1 to run this module, close database 2 and keep database 1 open. I've tried...- Deco1
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
