HELP!** ...Sharing XLA files - VISUAL BASIC... **HELP!
Posted by Arovo on March 12, 2001 4:21 PM
Firstly I have to say thanks to MrExcel for this resource!
(what a relief to find it... Thanks all!)
My problem is thus:
I have written a function using VISUAL BASIC (press ALT-F11 in Microsoft Excel 2000) which does a scientific calculation on two values. For example, when I use it in Excel I type the following in a cell:
=myfunction(A1,B1)
The function I have written works perfectly, but HOW do I share it with a colleague?
That's the question... how do I send this XLA file created in Visual Basic with Excel 2000, to a colleague so they can load it and get the same results as me?
.
.
.
Okay, I've tried getting them to save it in the FOLDER:
'C:\WINDOWS\Application Data\Microsoft\AddIns\'
and asked them to run Excel 2000 and try calling the function:
=myfunction(A1,B1)
BUT
it doesn't work EVEN when I specify the function as as:
=C:\WINDOWS\Application Data\Microsoft\AddIns\'myfunction(A1,B1)
even though that's how it's specified when I load back my original file - the only one that works when I've loaded it - if I try and re-use the function - IT WON'T WORK!
HAS EXCEL INVENTED SINGLE-USE FUNCTIONS?
What am I doing wrong... in other words:
HOW DO I GET MY APPLICATION TO WORK?! :-)
Thank you.
A postcard to anyone who can help (just email me your address - I'm in Australia :-)
THANKS FOR ANY HELP!
Posted by aROVO on March 12, 2001 7:15 PM
PLEASE HELP IF YOU CAN - IT'S VERY URGENT! i'LL LOVE YOU IF YOU CAN HELP!
Posted by Mark W. on March 13, 2001 7:08 AM
Check your Library folder for myfunction.xla
Posted by ml on March 13, 2001 12:40 PM
Re: PLEASE HELP IF YOU CAN - IT'S VERY URGENT! i'LL LOVE YOU IF YOU CAN HELP!
If you send him the XLA file, just have him put it
in any directory. Then in Excel, go to Tools->AddIns
and click on Browse. Locate the Add-in file, and then
it will ask you if you wish to copy the add-in to the
MS library or something. This is optional.
Returning to the spreadsheet, all functions in that add-in
should be available.
I have an XLA file I created with some custom functions
that I have saved on a network drive. Anyone that wants
to use it just follows the steps above once, says no when
it asks about copying to the library, and they are done.
I have them click no so that the files they create reference
the file on the network drive when using the formula, so that
it doesn't give a missing file error in case people have
MS Office installed in different directories on their computers.
