Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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
  • 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Hi Folks, This article is intended to throw some light or basically give an idea towards taking the first step in the world of Systems Administration. This would in the real context of the word "Systems Administration" which would mean right from…
Steve Jobs once said that Blu-ray is "a bag of hurt". As Macs users well known, things haven’t settled down (at least not from Apple’s perspective). Several years after that comment, Mac OS X still doesn’t support Blu-ray playback, nor has any Mac s…
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 > …
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

580 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