?
Solved

Excel VB question

Posted on 2014-10-13
3
Medium Priority
?
131 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 2000 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 26

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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
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…

777 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