|
Subject:
|
Excel Conversion
|
|
Posted By:
|
echovue
|
Post Date:
|
12/13/2005 10:01:33 AM
|
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
|
|
Reply By:
|
vemaju
|
Reply Date:
|
12/13/2005 10:22:31 AM
|
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
|
|
Reply By:
|
echovue
|
Reply Date:
|
12/13/2005 11:44:13 AM
|
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
|
