View the code in a add-in

[sh0t2bts]

Hi I have a excel add-in that I want to view the code of the functions of,
can someone tell me if this is possible?

The add-in is saved as a .xla file

Many Thanks

Mark

 

[Ron de Bruin]

Hi

If you know the password?

Alt-F11
Double click on the Add-in in the project explorer
Enter the password

 

[sh0t2bts]

When I go into the add-in the only code there is "Declare Function
function_name" repeated for 6 functions but I can not see the functions??

Any ideas?

Cheers

Mark

 

[Frank Kabel]

Hi
maybe the author has used a DLL for his coding. You may contact the
author directly (or tell us the name of your addin)

 

[sh0t2bts]

The name of the add-in is "Erlang for Excel" the add-in file is called
"Westbay Traffic.xla"

There is no other files that come with the add-in only the .xla file


Cheers

Mark

 

[hrlngrv - ExcelForums.com]

sh0t2bts wrote..

When I go into the add-in the only code there is "Declar Functio
function_name" repeated for 6 functions but I can not see th

functions?

If all you see is Declare statements, then you're .xla -add-in i
nothing more than an interface between Excel and functions in
compiled .EXE or .DLL file, in which case there's no source code fo
you to see. Looks like whoever wrote this add-in took the correc
steps to prevent users like you from seeing the source code for thes
functions

 

[Frank Kabel]

Hi
as this looks like a quite professional tool (at least you have to pay

100$ for it) I'd assume the following:

- it probably installs just more than only this XLA
- I would assume they've installed a COM addin (dll file)

You probably won't be able to get to the code (as this is their
intellectual property). In Germany even trying to break the protection
is NOT allowed by law.

Maybe the vendor is willing to share some code (for a fee of course).

 

[sh0t2bts]

I have just paid $109 for the package,

I will try the vendor and see what they say


Cheers

Mark

 

[Frank Kabel]

Hi
to be honest: I doubt they give you the code. that's their business
model. Or does MS give away its code )