TrailShredder
asked on
VBA Error Since Excel 2016 x64
I know "0" VBA so bear with me on this....
I had an in house developer several years ago that developed a spreadsheet that we use to manage our employee hours. This sheet was developed in Excel 2003 32bit and pulls data from an access 2003 32bit database. We are in the process of upgrading to Office 2016 x64. I get this error when I open the spreadsheet and have no idea where to begin to troubleshoot since I am not familiar with VBA coding. Here is the error and attached is a screen shot of the code.
Provider cannot be found. It may not be properly installed.
compile.JPG
I had an in house developer several years ago that developed a spreadsheet that we use to manage our employee hours. This sheet was developed in Excel 2003 32bit and pulls data from an access 2003 32bit database. We are in the process of upgrading to Office 2016 x64. I get this error when I open the spreadsheet and have no idea where to begin to troubleshoot since I am not familiar with VBA coding. Here is the error and attached is a screen shot of the code.
Provider cannot be found. It may not be properly installed.
compile.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I guess so.
Another possibilty are the references. Take a look at Tools/References in the VBA IDE.
Another possibilty are the references. Take a look at Tools/References in the VBA IDE.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Reverting to 32 bit office fixed the issue.
ASKER