Excel file broken when running on Mac with VM running Win7

[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

[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.

[AMT7565]

Thank you, I am looking into this to see if this is a platform issue.

[loukingjr]

you're welcome. hope you get it sorted.

[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.

[loukingjr]

glad you got it working.