I have recently upgraded from Excel/Access 2003 to 2010. I am working on moving a macro database from a co-workers computer to my computer since her last day is coming up. She is still on Access 2003 and the macro was created on 2003. When I open the macro in 2010 and try to run one of the modules it does not work and gives me this error:
MacroError.png
"The format in which you ar eattempting to output the current pbject is not available"
The function is supposed to export a list to excel. My immediate reaction is to look at the code to see where it is reffering to; however, when I try to access the VBA editor an error pops up that says "Project is not available."
There doesn't appear to be a password, but I am unsure.
I tried unsharing the database, no progress.
Then I tried adding/removing a digital certificate, both no luck.
I also tried decompiling the database and that didn’t work either.