Excel for Windows Add-In Conversion

Posted on 2003-03-27
Medium Priority
Last Modified: 2011-09-20
Hi all,
I am trying to use an Add-in called Stats Plus.  It was originally developed for Office 2000 (Windows).  When I try to install it I get the following error:  
Compile error in hidden module:  Functions

I underdstand that it may be impossible, but it seems like it's feasible to run the add-in on my Office X (Mac 10.2) system.  Any help in getting this working would be greatly appreciated.

Thank you.

If you need more detail I woul dbe more than happy to provide it.
Question by:Schandor
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 81

Accepted Solution

byundt earned 1000 total points
ID: 8222790
One of the selling points of VBA macros is that they are cross-platform. Except for a very few commands, what works on the Mac should work on a PC (and vice-versa).

Can you open the .xla to look at the code? Option + F11 should open up the Project Explorer menu. From there you should be able to see the .xla file. Double click it and see if you can look at the code.

For debugging purposes, if you can capture the code, try pasting it in your workbook (thereby eliminating the need for the .xla add-in). The hope is that Microsoft's syntax checker and error messages will flag the problem.

Author Comment

ID: 8222887
I attempted to look at the code but it is password protected. I wouldn't suppose anyone knows of a cracker for that sort of thing.  I will attempt to call the manfaturer and see if they would be willing to give me the password.

I'll let you know what I come up with.

Thank you.
LVL 81

Expert Comment

ID: 8228932
I found cracker software pretty quickly using Google--but I think going through the manufacturer is the better course of action.  They really ought to support the macro for Macs.

Author Comment

ID: 8232280
When I contacted the manufacturer (for the second time) the tech told me that there was an unsupported version that should work for Mac.  After downloading it from their FTP Site it works with some quirks but gets the job done.  Wish they would have told me about this the first time I called as it would have saved me some points.

Oh well, all's well that ends well.

Thank you for your help.

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

Yesterday Apple introduced their revolutionary new iOS 5 operating system that claims to be the ultimate mobile technology interface. One of the biggest innovations of the new operating system is the introduction of the iCloud computing network. Thi…
Article by: Justin
In light of the WannaCry ransomware attack that affected millions of Windows machines, you might wonder if your Mac needs protecting. Yes, it does and here is how to do it.
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…

762 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