February 28th, 2010, 10:12 PM
Thanks for the post. Yups I have been through this msdn article. But this post reiterates the same thing. I can register my dll using the declare statement. But I cannot somehow make...
February 24th, 2010, 08:21 PM
Thanks for the replies guys,
So I checked on two things ....
ThisWorkbook.path -> Would return the path where my workbook is
Application.path -> Would return me the path where excel.exe is
February 23rd, 2010, 08:43 PM
Just by double clicking on the sheet. Is there something called default path where vb would search for the dll. Can I somehow see that path in my program ?
February 21st, 2010, 12:11 AM
There is only one computer.
The only difference I can think of is that the first file came from a friend of mine and it may be written with a old version of MS Excel.
I am using Office...
February 18th, 2010, 03:43 AM
Thanks Hannes and WoF for the reply,
I actually got an excel file and the "Des.dll" from my friend. His macro in his Excel sheet runs perfectly fine calling the "Des.dll".
No matter where I...
February 16th, 2010, 11:56 PM
I am making a makro for an excel file and having some problem calling the function in a dll file. My dll file is located in the same directory as my excel file. I am using the below...