not sure which code you will need. I have an access 2007 database which opens an excel file to receive information. In the excel file I am trying to call an access function which will close the excel file and then preform some calculations.
When I had both access and excel in 2010 it worked great. But when I go to run the same thing in 2007, when I use the getobject("acce ss.accdb")to run the function, it actually opens another database and none of my variables are set in it.
I need some major help because I am not good with working with 2007 or 2010 yet and I am very frustrated with this at the moment.
When I had both access and excel in 2010 it worked great. But when I go to run the same thing in 2007, when I use the getobject("acce ss.accdb")to run the function, it actually opens another database and none of my variables are set in it.
I need some major help because I am not good with working with 2007 or 2010 yet and I am very frustrated with this at the moment.