File not found: VBA_TOOLS.DLL

[mattman73]

I have been using this DLL on different PC/laptop but when I installed on a Windows 10 64bit OS, I'm getting this error on loading the dll I have double checked the location and I can not see anywhere where to unblock the dll.
Would I need to install .net framework and if so what version.
Thanks
Matt

[krishKM]

File not found could be something else but to answer your question, the project uses .NET 4.6

[mattman73]

Ok I have checked the .net framework and 4.7.2 is installed do you know if there are any other issues around the file not found.

[krishKM]

Is the file really on the location you say it is?
Within the DLL function, LoadLibrary (System.GetBasePath & "VBA_TOOLS.dll") is the System.GetBasePath or whatever funciton that returns the application path returning correct path?

[mattman73]

yes, double check the dll / bin folder location some code works on other PCs.

[krishKM]

Are you using the 64bit dll and 64bit dlls for bin folder? It also could be that dependency dlls from bin path are being blocked

you can get the x64 version from here: (beware functions may have changed from your version)
Dll and bin

[mattman73]

I'm using the 32bit version and I have checked the dll in the bin folder and none are being blocked, moving over to the 64bit version would take some time and then might cause issues with other install.
I just need to understand why the file is not loading, thanks you for your help.
Matt

[krishKM]

Ah okay, you are on 64bit but using 32bit dlls? I don't think the current setup would work because usually 64bits cannot load 32bit dlls. how about having both 64 and 32 bit dlls and your vba code
#if Win64 then load 64bit dll #else load 32bit dll #endif

would that be an option?

[mattman73]

yes it is 64bit os but 64bit dll do not work when running the 64bit dll I get run-time error '91', commenting out the on error resume next the error changes to run-time error '438' object doesn't support this property or method.

[krishKM]

64 bit os, 64bit office, you have tried 32 and 64bit dll and you are having issue with both dlls?

64bit office using 32bit dlls won't work
64bit office using 64bit dll should work. Please check this with the current sample file.
32bit office with 32bit dll should work too.
32bit office with 64bit dll won't work.

[mattman73]

64 bit os and 64 bit office and 32bit dll or 64bit dll not working using the sample code.

[krishKM]

has this been sorted matt?

[mattman73]

Hi
No, I never worked out why this did not work and had to move on to a different project so if you have any updates that would be great.
Thanks
Matt

[krishKM]

Interesting. You said same code works on other PC. Any chance you can share a sample project from you? Either dropbox or onedrive download link? or would it be possible to share your screen (any remote or skype rDP tool) so I can have a look to understand the problem?

[mattman73]

I have just moved to a new PC and using the same code the dll is not working now as the ShowDialogforfilearray is missing from the x64 dll, can you let me know what I can use instead to return the files string.
Thanks, Matt

[krishKM]

Latest changes are published. Please have a look