xll dependecy question

  • Thread starter Thread starter Bura Tino
  • Start date Start date
B

Bura Tino

Hi,

I've compiled an XLL but it only works on my machine! On other machines it
tells me that it is not a valid add-in. I'm suspecting this may be because
it might depend on something that came with Developer's Studio, which is not
present on other machines. So I used the "Depends" tool to get the following
dependencies:

c:\windows\system32\ADVAPI32.DLL
c:\windows\system32\GDI32.DLL
c:\windows\system32\KERNEL32.DLL
c:\windows\system32\MFC42D.DLL
c:\windows\system32\MSVCP60D.DLL
c:\windows\system32\MSVCRT.DLL
c:\windows\system32\MSVCRTD.DLL
c:\windows\system32\NTDLL.DLL
c:\windows\system32\OLE32.DLL
c:\windows\system32\OLEAUT32.DLL
c:\windows\system32\RPCRT4.DLL
c:\windows\system32\USER32.DLL
c:\windows\system32\WINMM.DLL
c:\windows\system32\WS2HELP.DLL
c:\windows\system32\WS2_32.DLL

Does anyone know if any of these come only with Developer's Studio (or give
me another suggestion as to what I'm doing wrong!)?

Thanks!

Bura
 
Chrissy said:
How do I make and XLL form my Excel project?
Click to expand...

Please ask a more specific question. What do you mean by your excel project?
What programing language are you using and what are your goals?
 
Bura Tino wrote
Please ask a more specific question. What do you mean by your excel project?
What programing language are you using and what are your goals?
Click to expand...

In the MS Excel Programming news group I asked , in reply to a post,
"how do I make an XLL from my Excel project.


ummmmm - more specific - ok - VBA project in Microsoft Excel
which came as part of the Microsoft Office XP suite of applications.
It used VBA (Visual Basic for Applications) as the programming
language which comes bundled with Microsoft applications.


Seriously - how does one make an XLL? Can it be done with
and Excel project? Does this answer apply to all Excel versions
or just some? If some, which ones?

Chrissy.
 
You built a debug version of the library. Hence the "D" at the end of
the listed file names. REbuild a release version, and it should work.

Also, to the other poster in the thread - you cannot make an XLL out
of a VBA. An XLL is a DLL that has a couple of defined entry points
and a new filename extension. Basically, your best bet is to use C/C++
to create the DLL but anything that can generate one can be used.
 
Chrissy,

An XLL is a Windows DLL file with specific procedures that are called by
Excel when then the DLL is loaded. XLL's are written in C/C++, not VB/VBA.
You can't take a VBA project and compile it to an XLL.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)
 
Thanks - thought that may be the case but as I had not seen any
XLLs was not sure.

Chrissy.

Chip Pearson wrote
 
Back
Top