Hi Everyone,

I usually hang out on the Access forums, but need your expertise for a small project I am working on. The project is relatively simple. I have written three VBA functions which perform a simple analysis on a series of numbers to determine frequency and a few other things. They work great.

The problem is that the person I created this for is still using Excel 97, and gets a 'FM20.dll is missing' error when he trys to open the spreadsheet.

Do any of you know what tweaks I could put in place to allow him to open this, or does anyone have the means to help me convert this back to 97? The earliest version I have access to is 2000.

Thanks

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Hi,

Excel 97 is missing Microsoft Forms 2.0 Object Library.
Take a look at Tools - References in VBE and try to browse the missing object library.
It usually stays in Windows\System32 folder

-vemaju

Thanks Vemaju,

I fear he may have more problems that just a missing reference. I'll give that a go however and see if I can get it to work.

I'll let you know, thanks again,

Mike

Mike
EchoVue.com