Link to home
Start Free TrialLog in
Avatar of Fritz Paul
Fritz PaulFlag for South Africa

asked on

Access VBA stops understanding "Dim excelApp As excel.Application"

My Access project stopped working, Suddenly it does not recognise a statement like
"Dim excelApp As excel.Application" . It worked an hour earlier. Even if I restart my computer it still gives error message like below. I also include picture of my references.

I copied the same form to another project and it works. What could have gone wrong?

I will try to solve the problem by copying everything over to a new project.

Can you say what went wrong? How can I fix it? How can I prevent it from occurring?

User generated imageUser generated image
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fritz Paul

ASKER

Well spotted! I love it!