Solved

I have a XLSM where the macro/VB is no longer working, can someone review

Posted on 2015-01-18
19
109 Views
Last Modified: 2016-02-11
An XLSM was created to consolidate files and generate an email it is no longer working. I don't know enough to know how to fix it.
MonthlyRepStatement-V02.xlsm
0
Comment
Question by:trayceejay
  • 8
  • 8
  • 3
19 Comments
 
LVL 18

Expert Comment

by:Simon
ID: 40556215
More information please: At what point in the process is it failing?
Do any of the buttons still work as expected?
Has anything significant changed in your environment - e.g. Office version?

Note: this looks like a follow-up to http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_28518112.html
0
 

Author Comment

by:trayceejay
ID: 40556261
Yes, this is that same file. Environmentally speaking, nothing has changed. I had a virus that did something and I needed to reinstall the license of Office 2013 and it required getting a new license key because the OEM code that came with my PC was lost. Other than that, as far as I know nothing has changed.

None of the buttons works as expected.
0
 
LVL 18

Assisted Solution

by:Simon
Simon earned 250 total points
ID: 40556315
When I open your workbook (admittedly in the Mac2011 version of Office), none of the buttons work for me either. They just don't behave as buttons when clicked.

Could you try adding an ActiveX commandbutton object to a brand new workbook and tell us if you get an error message. If the problem doesn't just exist in that specific workbook I think you have the ActiveX problem caused by the December 2014 MS security update. The fix for that is shown in this MS suppport link (with fixit).
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:trayceejay
ID: 40556319
I am not sure that I know how to do that.
0
 
LVL 18

Expert Comment

by:Simon
ID: 40556343
Do you have any other workbooks with buttons on? If so, do they work?

If not, please try this very simple test workbook (blank with just a button in). It should just say Hello when you click on it.ButtonTest.xlsm
0
 

Author Comment

by:trayceejay
ID: 40556348
I researched the MS support link you provided here and that was exactly my problem.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40556365
Looking at the file I can see that it is linked to outlook 2013 is this the version you have ? When it was developed it was Outlook 2007 did you change it from then ?

gowflow
0
 
LVL 29

Accepted Solution

by:
gowflow earned 250 total points
ID: 40556371
I changed in your file the reference to outlook 2007 and it worked perfectly.
gowlfow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40556377
Oops your quick !!! I know your very busy but ... can we just exchange few things ?
gowflow
0
 

Author Comment

by:trayceejay
ID: 40791124
My file has an error and in between each rep it is asking me to continue, end or debug can you review?

Doc1 is a screen shot of the error
MonthlyRep file is the actual macro file
I also attached the three files I am working with.

I am not sure if there is something in the file we need to change or not again...sorry I don't know enough about VBA and excel version changes/tweaks.
Doc1.docx
MonthlyRepCommissionStatementGenerator-w
OP512-APR2015.XLS
SA612-APR2015.XLS
SA646-APR2015.XLS
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40791673
ok just quickly in here

when are you getting this error I mean when you press what button ?
Selecting the files ?
Generate Monthly Rep statements ?
Generate Emails for Sales ?

gowflow
0
 

Author Comment

by:trayceejay
ID: 40791710
every time the reps are parsing through each of the files...
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40791752
I saw the file quickly it seems you have a new version of outlook it is outlook 2013 ? did you just installed it and the problem started ?

You did not answer my question. What button you activate so it give you the error ?

I tried the file and it is fine with outlook 2007. No error.
gowflow
0
 

Author Comment

by:trayceejay
ID: 40791789
yes i have outlook 2013, i have always had

happens with either button.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40791860
If you noticed on this question you had accepted when I posted that I changed to oulook 2007 and it worked perfectly. Please see the threads again.

I still don't know what error you get what is the message. I saw the instruction in yellow that you posted but don't know what is the error that is caused maybe then I could help.
gowflow
0
 

Author Comment

by:trayceejay
ID: 40844575
I am getting an error on the one spreadsheet and no reason why. I have attached the files I am using. Please help!
SA646-MAY2015.XLS
SA612-MAY2015.XLS
OP512-MAY2015.XLS
Doc1.docx
MonthlyRepCommissionStatementGenerator-w
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40845346
Yes I just checked it out and here is the problem:
In all your files (booking, shippments and commissions) you had mentioned that the data was in sheet SUBTOTALS

but it happened so that the file it is failing on
SA612-MAY2015.XLS
has the sheet SUBTOTAL

it is missing 'S' at the end just put S so it Is SUBTOTALS and run the macro all should be fine.
gowlfow
0
 

Author Comment

by:trayceejay
ID: 40846155
Oh my how simple. I checked the PriSlp field....ugh! sorry! but thank you!!!!!!!
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40846167
Your welcome
gowflow
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Use Windows Task Scheduler to print a Word document weekly so your printer ink won't dry out.
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.

821 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