Share A Toolbar That Calls Macro From An Add-in

Mar 14, 2008

I have created some macros that need to be used in several workbooks by more than one users, so I put them in an add-in and gave them instructions on how to get the add-in. I also created a toolbar with buttons calling those macros, attached it to a workbook the users can open, and instructed them to open that workbook once to get the toolbar.

Both the add-in and the toolbar workbook are on a network drive that my users can access, but when they get the add-in, it gets copied to their own add-in folder.

Here's my problem:
When a user tries to click on one of the buttons in the toolbar, the button tries to call the macro using the path that would be valid on my computer to get to my add-in folder. This path includes my user name, so it doesn't go to their own add-in folder: it goes to my add-in folder on that computer if I ever logged in on that particular machine, or it goes nowhere.

When I created the button, I attached the macros by referring to the add-in workbook by name only, without referring to a path, so I don't know why MY path ended up defined on that toolbar.

How can I go around this? I manually relinked all the buttons for that user, and I can do it for the other users (there aren't that many users nor that many buttons), but I'd rather avoid it: I'll have to re-do it if the toolbar is updated and it just seems like more work than should be necessary.

I'm also opened to suggestions on a better way to share those macros. They can't be attached to the workbooks because we use new workbooks every year - they're emailed to us by the people who create them and for a variety of reasons, pasting everything into a workbook of our own is not a good option.

View 11 Replies


ADVERTISEMENT

One Macro Calls Many

Sep 30, 2009

I have this code (below) that calls a number of other subroutines. It begins the process just fine, but then gets hung up upon completing the first macro called, Run_Educator_Report. What could be causing this?


Sub Run_All()
Call Run_Educator_Report
Call Run_Non_Educator_Report
Call Construct_Database_for_Graphs
ActiveWorkbook.Save
End Sub

View 9 Replies View Related

Macro To Transpose And Merge Calls Automatically?

Jun 19, 2014

I wonder is there a way that I can transpose and merge calls by using macro?

View 6 Replies View Related

Macro Calls A Unwanted Procedure During Runtime

Jan 14, 2010

I have a VBA application in Excel.
In a certain time, when the code is executed in the


Private Sub CB_ValidaHoras_Click()

View 11 Replies View Related

How To Share Macro(s) To Other Users So They Can Use It

Jan 7, 2014

How do I share a macro(s) to other users so they can use it? Each user has different location because we are working remotely.

View 1 Replies View Related

Multiple Spreadsheets Share The Same Macro

Feb 3, 2010

I currently have a macro that can be used by multiple spreadsheets. Is there that I can execute the macro within any specific spreadsheet without saving it in each spreadsheet. I just want to place it in a general spot so that in case there is modifications, I only have to change it in one place.

View 14 Replies View Related

Unable To Share Macro As Add-in Or Template

May 4, 2007

I created a macro in VBA that pops up a calendar with keyboard short cut and places the date in selected cell. It works great on my pc. I can't share the macro with anyone. I saved it as an add-in...installing the add-in did nothing. Then I saved it as a template...the template did not open with any macros associated. both cases, no errors. no message to enable to disable macro.

View 4 Replies View Related

Forms Toolbar Versus Control Toolbox Toolbar

Oct 19, 2006

which of these toolbars provides the better 'controls' to paste onto worksheets (as opposed to UserForms)? For those wondering, both toolbars contain some apparently similar controls, e.g., combo box, radio button, spinner etc. but there are differences in their behaviour it would seem...

View 2 Replies View Related

Share Workbook Option Disabled – Can’t Share Workbook

Mar 26, 2008

I have a large worksheet that for some reason I can’t share.

-It does not have any lists, that I know of, do not know how to see if there are any
-It does have validation, but I have other workbooks with listed validation that are shareable
-It is not protected
-Does not have any named ranges
-Is not read only
-I have saved it as another file name and no luck there
-I have copied the one sheet I really need into a separate file to try that it did not work,

View 2 Replies View Related

A2-A14=100%: Number Of Calls Column, With Number Of Calls

Jan 18, 2009

I have Problem column, with problems from A2 to A14. I have number of calls column, with number of calls from B2 to B14 and finally i have percentage column in which i want to automatically calculate problems percentage. I'm including my exel file.

View 5 Replies View Related

Add Button On Toolbar For A Macro

Oct 5, 2012

I have a macro and I want a button on the toolbar, once clicked on the button, I want the macro to run.

Is there any way to do this. If this can be done using add-ins, I doesn't know how to create a button for the same.

View 4 Replies View Related

Toolbar Macro Button

Jun 11, 2006

I've created a custom toolbar via Excel's toolbar wizard, to which I have added several macro buttons. However, when clicked, instead of running the assigned macro, Excel instead attempts to open my already open file?? I think I read something about having to manually change the buttons to refer to a .xla ??? Not sure though.

View 3 Replies View Related

Opening Workbooks From Macro In Toolbar?

Mar 13, 2013

What I'm trying to achieve.I'm trying to create a toolbar to have visible in excel which provides me with shortcuts to a selection of functions and some other useful documents.

I've created a document "Toobar 1.xls" in column B of which I have the file locations of the documents I want to open, the documents are moved from time to time and it is easier for other users to update the spreadsheet than vb.As you can see below I've written a piece of code to open up a document, I've created a function because there are a few documents I want to create links to and thought it would be cleaner to do it like this. This code is stored in "Module1" of "Toolbar 1.xls".

I've then created a new toolbar in excel and added a custom menu item and allocated it the macro "Pension_Credit_Calc".

When I run the code from within "Toolbar1.xls" it works fine, however if I try to run it from another workbook I get "run time error 1004". I suspect it's probably something to do with where I've stored my code,

PS. The reason I have not simply created a shortcut in the quicklaunch bar is that I will also be altering the workbooks once opened.

Code.

VB:
Function OpenUp(FileLocation) As String
Workbooks.Open (FileLocation)
End Function [code]....

View 2 Replies View Related

Activating A Toolbar Item From A Macro

Sep 24, 2009

From a macro, I am trying to activate the Excel dialgue that occurs when you click on a toolbar item.

Specifically I want the Find item (CTRL-F) to activate. I can use the .find method ok from a macro but I want the dialogue from Excel itself.

View 2 Replies View Related

Macro Recording Small Toolbar

Jun 28, 2007

When I try to record macro, the small toolbar which has two buttons "stop recording" and "relative reference" do not appear. I need to turn relative reference on.
Can you please guide me how can I make it visible to turn relative reference on?

View 9 Replies View Related

Assign Macro Error For Custom Toolbar

Mar 12, 2007

I have a custom toolbar containing several buttons which run several macros. Works fine except on exiting the programme and re-opening the workbook, if I try to use the custom buttons I get an error message which tells me it cannot find the ' name of workbook, name of macro' macro I then have to re-assign the macro which has been there all the time but without the file name in front of it.

View 7 Replies View Related

Macro Button On Quick Access Toolbar Disappears

Apr 15, 2014

I have written a macro. The macro in question simply shows a user form. There is far more code within the user form itself. It is designed to automatically format a workbook.

I saved the macro as an .xlam add-in file to the default folder. I then added a button for the macro to my Quick Access Toolbar. This seemed to work great.

However, when I open a new file that I want to run the macro on, the button disappears. In fact, a 2nd Excel window opens up on my task bar. The original window still has the macro button, but the new window does not.

View 5 Replies View Related

Excel 2013 :: Customize Macro Button Added To Toolbar

Dec 3, 2013

Upgraded to Excel 2013. Do i no longer have the ability to customize the look of my macro buttons i add to the toolbar?

View 2 Replies View Related

Email A File To Install A Macro, Toolbar & Button To A User. Re-explained In Post 19

Feb 17, 2009

I have finally come up with a macro and would like to install it to around 10 people's "Personal Workbook" in my department. Let me explain a bit further...

We use web-based software which has an "Export to Excel" option which we all use. The resulting data populates into a spreadsheet automatically.

I would like the user to be able to click on Tools/Macro/Run Macro and then run that particular macro. I assume that this macro should be in the "Personal Workbook" so that the macro will be visible no matter what worksheet they may have open?

Can this be done automatically/with a macro or must this be manually done?

I"m using Excel 2003.

View 14 Replies View Related

Sub Calls Sub Recup Value

May 22, 2007

I have two macros, Sub macro_Combs() calls Combin_6N()

In macro_Combs I must recover the values of the line in progress 500 step 28 to put them in vN(J) table of 10 élements.

The line in progress can go from 4 to 10 digits

if I make vN(J) = Sheets("feuil3").Cells(J).Value functions for 500 step 28 but with same the information of line 1 of feuil3

if I make vN(j)=cells(lig, col).value that does not function

Public lig As Integer
Public Col As Integer

>>>>1 ère macro

Sub macro_Combs()
For Lig = 1 To 100 Step 28
For Col = 1 To 1
Next..........

View 9 Replies View Related

Trying To Chart Calls Per Minute / Per Day

Dec 6, 2013

I'm trying to use some call data for some predictive staffing. I need to see the highest number of calls happening around the same time each day. I'll have to do this for a number of different lines, so working out a formula that could apply.

I have two columns, date and time stamps of the calls. A small sample is below.

7/1/13 5:50 AM
7/1/13 9:49 AM
7/1/13 10:33 AM
7/1/13 10:53 AM
7/1/13 11:19 AM
7/1/13 11:41 AM
7/1/13 12:07 PM
7/1/13 3:58 PM
7/1/13 4:03 PM
7/1/13 5:35 PM
7/1/13 6:27 PM
7/1/13 6:39 PM
7/1/13 7:37 PM

View 2 Replies View Related

Find Non Blank Calls

Nov 25, 2008

I need to create a formula that counts the number of blank cells to the right and then actually uses the value in the non blank cell.

The result requiired is that the formula will find the difference between 1 value, the next non blank cell and then will average the cells between to get the interval figures.

eg. Value1 is 50.
Value2(the next nonblank) is 60.
There are 4 empty cells in between.

I need a formula that will find the next Nonblank (Value2), calculate the difference between Value1 and Value2, then divide that by the number of blank cells + 1 and add the value to the left.

The cell in A2, calculated manually at the moment would be:
=A1+((A6-A1)/(4+1))
This would then be altered across the page so that A3 would be:
=A2+((A6-A2)/(3+1)

etc., etc.

Therefore the result returned across the blank cells would be:

A1 A2 A3 A4 A5 A6
Value1 BLANK BLANK BLANK BLANK Value2
50 52 54 56 58 60

View 9 Replies View Related

Count Hours Where Calls Are Received?

Jan 27, 2014

I am trying to count hours where calls are received between 8am and 5pm Mon-Fri. If just one call is received between 8am and 5pm Mon-Fri then only one hour would be counted. Calls in excess of one call in the same hour do not count more than one. So if two people called from 8am - 9am then that would equal 1 and if on call came in from 9-10 then that would also be 1. Attached is a sample output.

View 11 Replies View Related

Automatic Phone Calls From A Spreadsheet

Aug 17, 2009

Is there anyway to make phone calls automaticly from a spread sheet

I'm calling old customers and it would be easy to just press a button and it will dial for me

View 13 Replies View Related

Sequential Lookup Calls In One Cell

Aug 27, 2012

I'm updating someone's spreadsheet and so don't won't to add new cells or anything to it if possible. The problem I have is that I need to perform hlookup's of 3 cells, average them (some responses are non numeric) and then hlookup the output to give a final value.

The problem I have is that putting the lookups in one cell and then averaging them and looking up the average in another works, but all three steps in cell won't, it keeps choking on the non numeric responses.

Are their any work arounds to this, as the sheet has quite a bit of VBA code attached and I don't really want to have to add columns and then change the VBA code too.

View 2 Replies View Related

Concurrent Calls With Start And End Time?

Nov 23, 2012

I have a set of call data including start time and end time, with all calls on the same date. Now, how would I show in a sepearate column the concurrent calls being made. i.e how many calls are being used at the same time. This relates to how many channels I can suggest to someone with the maximum concurrent calls being made.

I have attached someConcurrent CaConcurrent Calls sample.xlsxsample.xlsx sample data.

View 3 Replies View Related

User Form Event Calls

Jun 1, 2008

if you can prevent an event macro from running at will.

The problem is occuring when I have a userfrom with various controls, and the change of one control triggers an event macro that changes other controls, this then in turn triggers further control change macros.

I have tried altering the macro name to things like optionbutton1_change, select, enter etc.

The only other way around it I can think of is to introduce a binary variable, but that will mean ensuring it os always the right value and then coding an IF statement on each event macro.

Therefore, I'm thinking there must be an easier way, some kind of switch ??? Something that says ignore any event macro when the control is changed as a result of different event macro.

- I'll include a small example below just to clarify what I am talking about.

private sub optionbutton1_click()

userform1.textbox1.value = "Test Change"

end sub

private sub textbox1_change()

msgbox "Change taken place"

end sub

What I am trying to achieve is getting excel to ignore the second macro when the control is changed by another macro rather than a user entry.

View 9 Replies View Related

Number Of Calls Made By A Person In A Month

Sep 5, 2013

The first column is "Person Name" and the second column is date in format "6/27/2013". I want a formula to calculate the total number of calls a person made in the month of June.

View 2 Replies View Related

How To Calculate A Number Of Calls Logged In A Shift

Jan 7, 2014

calculating the number of calls logged in a shift, based on a 3 shift system in a day. shift 1 from 08h00 to 16h00, shift 2 16h00 to 24h00, and shift 3 00h00 to 08h00. each shift receives a number of calls based on the time the call was submitted.

View 2 Replies View Related

Creating Main Menu On Userform Using API Calls

Jun 17, 2011

I am trying to create a "mainmenu". On a Userform using API calls.

Created a Userform and named it Form1.

Added a command button to the form and named it Command1.

In THISWORKBOOK code:

Private Sub Workbook_Open()
Form1.Show
End Sub

[Code] .........

I open the file and Form1 is shown with its command button. When I click the command button I get an error:

Run-time error 49:
Bad DLL calling convention.

What is the correct convention?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved