xll dependecy question

[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]

How do I make and XLL form my Excel project?

Chrissy

Bura Tino wrote

 

[Bura Tino]

How do I make and XLL form my Excel project?

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?

 

[Chrissy]

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?

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.

 

[Nils Benson]

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.

 

[Chip Pearson]

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)

 

[Chrissy]

Thanks - thought that may be the case but as I had not seen any
XLLs was not sure.

Chrissy.

Chip Pearson wrote