View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sunny sunny is offline
external usenet poster
 
Posts: 8
Default Calling DLL functions in Excel VBA

I made a dll and I used it in VBA
Like this:
Declare Function currentMilli Lib "exceltest.dll" () As Long

It's working on my computer in any folders.
But when I tried it on other's computer it worked only in the "My
documents" folder.
I expected that it would work if the dll file and the excel file are
in the same folder.
What on earth is going on? How can I make it available on other's
computer in any folders?
Thanks in advance.