Solved

Excel VB question

Posted on 2014-10-13
3
128 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 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 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

690 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