Search results

Here are the two attachments

I installed Office Pro 2016 I attached 2 documents. Code: I have an excel template with 20+ tabs. Each tab is a two digits # that represent a specialty. For example Family Medicine is 08, Internal Medicine is 11. In my database I have a table called tblProvider with three fields, Provider...

I reinstalled Office, however instead of Microsoft Office 14.0 Access database engine Object library it has 15.0, no 16.0 listed as an option. :banghead: Option Compare Database Public Sub dbcodeexport(ByVal exportfile As String, ByVal exportdir As String) On Error GoTo errorx 'Variables Dim...

I'm reinstalling my Office 2016. My colleague had the same issue, and after she completely removed Office and preformed a clean install she was able to select 'Microsoft Office 16.0 Access database engine object library'. I will post a replay with the results after I finish the install.

I don't have 'Microsoft Office 16.0 Access database engine object library' as an option in my list references for Access 2016. Can I download it from the net?

Sorry for the confusion. The library references on the left are from my 2010 access database and the library references on the right is from my 2016 access database.

:banghead::banghead::banghead::banghead::banghead:I wrote some code in Office 2010, when I upgraded to Office 2016 my code stop working when it is gets to the writting stage of the code. Instead of creating a new Excel and writing data, it keeps creating a blank Excel. This exact code works in...

I will try it and post the results. I attached a screenshot of my Excel template. If you come up with anything that may help please post. Thank you!

I'm trying to export a query via VBA in Access 2010 to a pre-formatted Excel 2010 spreadsheet that is located in a folder within my documents. The Excel template and the Access query headings match each other. I attached a screen shot of the query. Thank you in advance for any help you can provide.