Solved

VBA in Excel in Parallels for Windows doesn't work

Posted on 2014-12-17
5
550 Views
Last Modified: 2016-11-23
I built some VBA in Excel that morphs old accounting data from a "summary report" layout into a tabular layout in order to push the data into a new accounting system. The VBA won't run in the Parallels VM environment on my MacBook Air. Some details:

The code resides under a worksheet in a centralized Excel 2010 workbook (XLSM). It's configured to morph the data on 15 otherr XLSX files.
The code lives directly under one of the worksheets in the centralized workbook. It's launched from a command button on the worksheet. (See image below.)
The code runs just fine where I developed it, on my old Dell Studio (Windows 7, Office 2010 laptop).
For the life of me, I can't get it to run in the Parallels VM environment on my MacBook Pro 5. In Excel, I've enabled Macros, moved the XLSM and XLSX drive to the C: drive in Parallels, set the XLSM file as a trusted document. I've done everything I could think of to tell Excel, "Trust the damn file."
Yet, when I click the command button (image below) I get nothing, no error, nothing.  

Worksheet with command button
0
Comment
Question by:jdana
  • 2
  • 2
5 Comments
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40505156
Do you know how to use Debug? If not then this article of mine may help.

In any case you can start debugging by going to the IDE and find the code behind the button, place a breakpoint (click in the left-hand margin) on the first line and then press f8 repeatedly to see what is happening.
0
 

Author Comment

by:jdana
ID: 40505188
I am the guru of debug :). It's not a debug issue. The code runs perfectly in a different Windows environment. In the MacBook Air / Parallels VM / Windows 7 environment the code won't launch at all (nothing, nada, zilch).

J
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40505198
The only other thing I can suggest is to install or reinstall Parallel Tools on the machine.
0
 
LVL 11

Accepted Solution

by:
Jamie Garroch earned 500 total points
ID: 40506568
I ONLY program in VBA within Parallels and have never come across this issue. So, some basic questions / ideas:

Can you open the code in the project window?
Are you able to compile the project?
Can you run the procedure assigned to the button manually from within the VBE?
When you say you've enabled macros, which of the 4 options have you used?
Can you insert another button in the sheet and if not, have you deleted all *.exd files from C: drive?
Which version of Excel and bitness?
Are you able to share a non-confidential xlsm file?
0
 

Author Closing Comment

by:jdana
ID: 40511887
Jamie,

You're the man. The EXD file trick got it done.

J
0

Featured Post

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

820 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