Can a workbook funtion without a missing dll ?

[PM]

Hello !

I have an Excel Workbook. Its code calls a dll.

If the user does not have the dll installed, he gets a compilation error.

Is there a way to get around this type of error ? If there was, the user
could use the workbook as any standard workbook and the functions powered by
the dll would simply remain silent.

Hope this question is not excessively stupid...

Pat

 

[Steven Deng]

Hello Pat,

I have this similar problem once. I chose to register all the dlls in the
user computers instead. (probably uncheck the dll file and delete the
compiler-errors may also work, since those codes are not needed for the
user)

I guess there may be some flags that can be used to indicate whether certain
dll is loaded. and you can code like this

' if flag defined then
' do something here
'else
' do something else
'end if

I am wondering if this is true for VBA (note: the above is my guess based on
my experience with the other langages). I am looking forward to knowing the
answers too

Sincerely,

Steven