Page 1 of 1

Excel file broken when running on Mac with VM running Win7

Posted: 14. Apr 2014, 02:43
by AMT7565
I have a VBA and Macros rich Excel file that works fine on Windows.

I recently bought a Mac and noticed that it does not support certain VBA functions. So the file was broken.

Today I have installed Virtualbox VM and running Windows7/Office 2013.

When running the file, I still get the same error:

"could not load on object because it is not available on this machine."

Then when using the date picker, I get this

"Compiler error in hidden module: Date picker, This error commonly occurs when the code is incompatible with the version, platform or architecture of this application."

Any suggestions folks
Thanks
AMT

Re: Excel file broken when running on Mac with VM running Wi

Posted: 14. Apr 2014, 11:34
by loukingjr
First this sounds more like an Excel/Office question than a VirtualBox question. That being said and since I'm not doing anything, it sounds like the VBAs or Macros were compiled on either a 32bit or 64bit Windows machine and your Windows guest is the opposite. Just guessing.

Re: Excel file broken when running on Mac with VM running Wi

Posted: 15. Apr 2014, 01:53
by AMT7565
Thank you, I am looking into this to see if this is a platform issue.

Re: Excel file broken when running on Mac with VM running Wi

Posted: 15. Apr 2014, 02:14
by loukingjr
you're welcome. hope you get it sorted.

Re: Excel file broken when running on Mac with VM running Wi

Posted: 19. Apr 2014, 00:15
by AMT7565
It looks like one of the objects in 2007 was not available in 2013. My developer has fixed it.
Nothing to do with VM looks like.

Re: Excel file broken when running on Mac with VM running Wi

Posted: 19. Apr 2014, 01:35
by loukingjr
glad you got it working.