Solved

Excel VB question

Posted on 2014-10-13
3
123 Views
Last Modified: 2014-10-14
Folks I need some help here.  I have created a script that is intended to sort data, put data column headers in and add the auto filter.  I have to install this on managers machines so my intent is to have each manager save the VB script as an add in file.  That way each time they open up the source data to be manipulated all they would need to do is hit the control key, cntrl+J, to run the macro.

Here are the issues I am running into:
1.  I am gettin a 400 error when I run the script on another machine,  I don't get this error when I run it on my machine.
2. The shortcut key doesn't work even after going into the macro options and making sure that the short cut key is set there.

I have included my data source file and my script code.  Can someone please help me figure this out.
PAR-Test1.xlsm
DlyReleaseActivity-20140903.csv
0
Comment
Question by:Rrave26
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40377965
Hi,

you had put your recorded code into sheet object module which is wrong.
now try it with the file i have attached.  Control K is the shortkey to run the macro.
PAR-Test1.xlsm
0
 

Author Comment

by:Rrave26
ID: 40380112
Thanks for your help, I am trying this out right now.  Can I ask why it was wrong to record the code into the sheet module?
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40380160
sheet vba object page is used for other purposes , like codes triggered by events called event handlers.

module is for the normal functions and procedures to place
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now