February 28th, 2010 09: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 07: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 07: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 20th, 2010 11:11 PM
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 02: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 10: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...