MOREFUNC equivalent 64bit OS / 32-bit Excel 2010/2013

[domtrump]

I have searched and it does not look like it is possible to use the MOREFUNC add-in with any 64-bit OS. I'm running Win 7/8 64bit (2 different machines). One running Excel 2010 and one 2013 (both 32-bit). If there is not a MOREFUNC version available for this configuration, can anyone recommend a similar add-in with custom functions that will work?

I appreciate any suggestions/recommendations.

Thanks.

-Dom

 

[MARK858]

I've just installed MOREFUNC on a laptop with a Windows 7 64 bit OS running 32bit Excel 2010 and it appears to be running fine (only tested 5 functions so far though)

 

[domtrump]

Windows 7 64 bit OS running 32bit Excel 2010 and it appears to be running fine (only tested 5 functions so far though)

Hmmm. That is my environment, but the first two functions I tested result in #NAME?. The installer would not add the menus to my Excel so I added the .xla & .xlam files manually. The menus and functions are there, but don't seem to work. The version I'm using is 5.06. Is that what you tested? Is there a newer one?

 

[MARK858]

Nope same version 5.06. Have you checked Tools - references in the VBE to make sure the Morefunc references are checked

 

[domtrump]

They weren't checked, so I checked them. Same result #NAME? What functions were able to test successfully? I tried DATE.DIFF and FILENAME.

 

[MARK858]

DATE.DIFF was fine on my laptop, I will try FILENAME

 

[MARK858]

FILENAME is ok as well.

Excel Workbook
	A	B	C
1	09/11/1967	20/03/2015	47 years 4 months 11 days
2			C:\Users\ANDYW\Desktop\Book6.xlsb
Sheet11

 

[domtrump]

Just not happening for me A shame.. these would be really useful formulas. Everyformula yields #NAME?

Do you happen to know if the creator of this is still around? Support website? I see the project hasn't been updated since 2007.

-side note: EVERY time I insert one of the Morefunc formulas, my NumLock turns off! Is this normal?

 

[MARK858]

EVERY time I insert one of the Morefunc formulas, my NumLock turns off! Is this normal?

On some functions, I guess Laurent Longre is using Sendkeys in some of the programming.

Do you happen to know if the creator of this is still around? Support website?

I am not aware of any currently operating Support website and as you can see in the link below the creator is not available
English pages | xcell


Silly question but have you shutdown and reopened Excel since installing the add-in?

 

[domtrump]

yes. shut down, rebooted.

Looked on Google - there don't seem to be any other add-ins that are similar to this (found one - Ozgrid function add-in).