Fritz Paul
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?
"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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER