Thread: Check and install Morefunc automatically

Hi!
Iv'e made a worksheet that uses INDIRECT.EXT from Morefunc.
I'm going to give this worksheet to a bunch of people and the problem is that they will - in most cases - not have morefunc.
It would be nice to have the worksheet to automaticly check if Morefunc is installed and popup a text to install it if it's not installed or, even better, begin to install it automaticly if it's not installed.

That's your thoughts about this?
Is this possible?
Or do you have better idea?
And yes, I want to use INDIRECT.EXT even though it makes trouble for the users.
Right now I've written a text in the beginning that explains that Morefunc have to be intsalled, but it just doesn't feel right.

One thing you could try, is to call the function from VBA when the workbook opens, and if there is an error, pop your message.

I don't have morefuc, so I can't test if this works if you DO have morefuc. It works if you DONT have morefunc. But of course you need both to make this useful

You need to paste the code on the workbook module page

Private Sub Workbook_Open()
    On Error GoTo myError:
    Application.WorksheetFunction.indirect.ext
    GoTo ExitHere:
myError:
    y = MsgBox("Please download morefunc from the web")
    ActiveWorkbook.FollowHyperlink Address:="http://xcell05.free.fr/morefunc/english/#Download", NewWindow:=True
ExitHere:
End Sub

If it still launches the website when you do have morefunc, you will need to adjust the line of code Application.WorksheetFunction.indirect.ext
so that id doesn't throw an error. I would have tested this, but the website that downloads morefunc doesn't seem to be working atm

Originally Posted by shg

I've heard that you can embed MoreFunc in a workbook, so that it does not require installation by each user.

I've heard that too, and that would certainly be the nicest sulotion.
But I think that that's just a rumour 'cause I haven't seen a sulotion to this anyhere.
But if there's someone sitting on this info... this is the place to release it...

Fanx Mallycat!
But I can't really get it to work.
I've never used VBA before so maybe I'm doing it wrong.
I opened a new workbook and selected Tools/Macro/Visual Basic Editor.
Then I right-clicked on Page1 and selected Insert/Module.
In the Module1 I pasted the script you gave me and saved it all.
(Sorry if the menus and other stuff isn't correct english, 'cause I'm translating from swedish)
See http://danielh.com/test.jpg
When I open the workbook I got no promt. So far so good. But I also open it on a computer with Excel that has NOT got Morefunc installed. And .... no promt here either. So I don't think I got it right.

Originally Posted by DonkeyOte

You can embed morefunc.xll into a workbook assuming you are running an XL version pre XL2007 thereafter the functionality ceases (at present, AFAIK).

To embed pre XL2007: Tools>Morefunc>Embed Morefunc in the workbook

Does this mean that I can embed it with a Excel 2003 and open it correcly with a Excel 2007? Or will do I have to open it with Excel 2003 as well. If that's the case, this would not help because the users I spread it to will in many cases have Excel newer than 2003.