By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,775 Members | 1,432 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,775 IT Pros & Developers. It's quick & easy.


P: 2
hi all,

my issue is this; from what i understand, if i add a reference to 'microsoft office 12.0 object library", then in my VBA i should be able to create a class like this:

Expand|Select|Wrap|Line Numbers
  1. dim oAcc as Access.Application
now, i have done this in my VBA project and to no avail. using:
Expand|Select|Wrap|Line Numbers
  1. dim oAcc as Object
  3. set oAcc = CreateObject("Access.Application")
seems to work quite well; but i have problems with opening the database.

can some please explain to me how to get things so the first option to work as i am fairly new to VBA and having access to all the procs/functions of a class would be very useful.

thanks in advance...
Mar 19 '08 #1
Share this Question
Share on Google+
2 Replies

P: 2
hi again all;

ok, i should have used the "Microsoft Access 12.0 Object Lib..." etc...

worked it out... :)

cheers and thanks
Mar 19 '08 #2

Expert Mod 15k+
P: 31,489
No worries and thanks for posting back.

Application Automation may provide some extra assistance for you.

Welcome to TheScripts :)
Mar 20 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.