MORFUNC FOR Excel 2010 ??

We've been using Morefunc for 8 years.  My firm now is using Excel 2010 and my workbooks that rely on Morefunc have been crashing.  I've tried every solution I've come across online, but the problem persists.

I'd appreciate any help.

Thanks so much.
cmmcginnAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Russell FoxDatabase DeveloperCommented:
From Download.com:
Editors' Note: This add-in, written in C++ (not VBA) is no longer maintained by Laurent Longre. You can use it freely but the code is protected...Version 5 adds compatibility with Excel 2007. It still works in the 32-bit versions of Excel 2010 and 2013 but not in 64-bit versions.
I think you're going to need to figure out which functions you need and then look for individual replacements for them, preferably as VBA so you'll keep compatibility with new versions. If you can list which functions you use, the Experts might be able to point to specific solutions, or you can use the EE "hire me" function to get an Expert to build you something (not me - my VBA is pretty rusty). Sorry, probably not what you wanted to hear, but I haven't seen anything that tries to replace everything MoreFunc did, nor is there a way to "upgrade" it to 64-bit.
0
Russell FoxDatabase DeveloperCommented:
One suggestion I've seen is to set up your machine to dual-boot, giving you a 64-bit machine for most stuff and a 32-bit machine just to use MoreFunc.
0
cmmcginnAuthor Commented:
Thanks.  We're using 32-bit Excel 2010.  The only function we use is INDIRECT.EXT.  I don't know why Microsoft hasn't made this a native function (seems obvious that users would need it).

Do you know if someone else has created an equivalent function?

Thanks again.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Russell FoxDatabase DeveloperCommented:
There's a macro that an Expert posted here, but I haven't tried it.
0
cmmcginnAuthor Commented:
Thanks.  I'll take a look when I have more time.  Skimming over the description, though, I'm not sure it will pull from closed workbooks (though that's the subject of the thread).

Much appreciated.
0
Russell FoxDatabase DeveloperCommented:
Here's something I found, but you'd have to tweak it to work like the original. Sorry I couldn't be more help.
Sub GetDataFromClosedBook()
	
	Dim xlData As String

	'File location & target range:
	xlData = "='C:\[MyExcelFile.xls]Sheet1'!$A$1:$D$5"

	'Link to worksheet:
	With ThisWorkbook.Worksheets(1).Range("E1:H5")
	.Formula = xlData

	'Convert formula to text:
	.Value = .Value

	End With

End Sub

Open in new window

0
cmmcginnAuthor Commented:
Thanks.  I'm under too much time pressure to try anything right now.  I'm not sure I understand how to implement these macros.
0
Russell FoxDatabase DeveloperCommented:
No worries, you can just close the question.
0
cmmcginnAuthor Commented:
No time to pursue solution. Thanks for trying to help.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cmmcginnAuthor Commented:
Must close question.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Spreadsheets

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.