[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MORFUNC FOR Excel 2010  ??

Posted on 2014-08-26
10
Medium Priority
?
149 Views
Last Modified: 2014-11-23
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.
0
Comment
Question by:cmmcginn
  • 5
  • 5
10 Comments
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40286255
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
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40286257
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
 

Author Comment

by:cmmcginn
ID: 40286303
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 14

Expert Comment

by:Russell Fox
ID: 40286313
There's a macro that an Expert posted here, but I haven't tried it.
0
 

Author Comment

by:cmmcginn
ID: 40286556
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
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40288305
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
 

Author Comment

by:cmmcginn
ID: 40288595
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
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40288613
No worries, you can just close the question.
0
 

Accepted Solution

by:
cmmcginn earned 0 total points
ID: 40450973
No time to pursue solution. Thanks for trying to help.
0
 

Author Closing Comment

by:cmmcginn
ID: 40460441
Must close question.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question