Solved

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

Posted on 2015-01-18
19
108 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Viewers will learn the basics of using filtering and sorting in Excel 2013.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

831 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