How To Use External VBA Custom Function In Excel ?
 

I am using Excel 2003 and Excel 2007.

I would like to compile a VBA Function to an .exe and place it somewhere.
Then I would like my excel use that compiled Function.

1st) I can use VB to generate an .exe of the function. Where could I
place this?? Can it be embbed in the excel sheet so user don't need to look
for it??

2nd) If its internal or external, I would I reference the .exe function to
my my excel spreadsheet ???

Thank You,

G

How To Use External VBA Custom Function In Excel ?
 

hi
excel VBA has no built in functionality for this. you would do better to
create your function as an addin and disturbute that way. excel is far better
suited for that.
but you can do a google. there are third party kits out there that claim to
be able to covert to .exe. i have never used any but years ago i did check
into converting an access database i developed into an .exe and i seems to
remember running across some. and i don't remember any of them being free.
and since i have never used any, search and use at your own risk.

regards
FSt1

"G" wrote:

I am using Excel 2003 and Excel 2007.

I would like to compile a VBA Function to an .exe and place it somewhere.
Then I would like my excel use that compiled Function.

1st) I can use VB to generate an .exe of the function. Where could I
place this?? Can it be embbed in the excel sheet so user don't need to look
for it??

2nd) If its internal or external, I would I reference the .exe function to
my my excel spreadsheet ???

Thank You,

G