Forum Discussion

Mike1983's avatar
Mike1983
Copper Contributor
Sep 07, 2019

ODBC driver issue in Macro VBA

Hi,   I ve got an issue with ODBC driver once using Macro. In very short Macro works fine when I am using 2 xlsx files (it compares some data so firstly I am selecting and loading 2 files). However...
excel
Macros and VBA
office 365
IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Sep 09, 2019

Hello Mike1983 ,

 

this may not be what you want to hear, but the 64 bit version of Office should really be the default installation these days. It's only a few legacy add-ins that still require 32 bit Excel and you may not even run these.  64 bit Excel can use more of your computer's memory and will run better.

Mike1983's avatar
Mike1983
Copper Contributor
Sep 15, 2019

Hello IngeborgHawighorst. 

Thanks for reply. I've re-installed from 32-bit verstion to 64 bit and now it is working when use XLSX and XLS fiels created on this version of Excel. However, if I try to use XLS file created before when I was using 32-bit version it is still the same problem.  So it is working once I am comparing XLSX with XLS both created on 64 bit Excel version.

I am still wondering if there is any way to handle the case when file was created on 32-bit Excel version. I understand that 32-bit is becoming legacy but if you got a file like this then you are stuck and macro will not go ahead 😞

 

Btw - first phrase was in Polish and it is "odbc driver does not support the requested properties".

 

Resources