![]() |
#1
|
|||
|
|||
![]()
I have a micro that manipulate a range of data from $A1 to $P180 and it is working fine. The macro process the data and generate different PivotTables.
The data in this rang ($A1 to $P180) is vary based on the person who will download it. For example, when an employee from medical department download this data, he will got data related to medical while an employee from purchasing Dept will download his Dept related data only. How can I send this macro to our users where they can use it over any data they will download from our main SAP system. All Departments data that all our users can download from the server are located in the same range ($A1 to $P180) but the problem is that the SAP system downloads it in XLs file under different sheet name. it is something like (SAP23987download). Your assistance is highly appreciated. Thank you. |
#2
|
||||
|
||||
![]()
If the macro needs to be available for any workbook they have open then you have two main choices. You can either get them to put it in their personal.xls or you can distribute it as an add-in. The add-in would be the better choice here but it would also come with a fairly significant learning curve.
|
#3
|
|||
|
|||
![]()
I highly appreciate your great support. I spent hours trying to complete the add-in issue but without success and I need your help.
My Macro3 is located in Microsoft Excel Macro-Enabled Worksheet (New3.xlsm). I have re-saved this file as “Excel Add-in” and not as "Excel 97-2003 Add-in". By default, the file was saved under D:\Users\myaccount\AppData\Roaming\Microsoft\AddIn s. Then, in this new Microsoft Excel Add-In (New3.xlam) file, I have customized the Ribbon tool bar and created a new group under data and linked this new group with the Macro3 which I found it in the Macro list (in the left side). Now, when I opened the original New3.xlsm file (Macro-Enabled Worksheet), I found Macro3 sign appear in the new data group that I have created in the Add-in file. The Macro3 sign in the New3.xlsm work fine even after I removed the Macro3 from it. The problem is when I sent this file to 3 of our users (as a test) and the Macro setting was enabled on their BCs; it did not work where they could not see the macro sign. |
#4
|
||||
|
||||
![]()
Hi,
Do they have the New3.xlam add-in installed? Is your intention to have it installed on each user's desktop or to have it saved communally in a shared network folder? |
#5
|
|||
|
|||
![]()
The answer is: To have it saved communally in a shared network folder.
|
#6
|
||||
|
||||
![]()
Okay, so
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
BITS | Project | 1 | 06-01-2011 09:37 AM |
Office 2003 stops working looking for network share | Tim Donovan | Office | 0 | 01-05-2011 11:32 AM |
![]() |
lohith.korp | Office | 2 | 09-27-2010 08:32 AM |
![]() |
AmrMahmoud1982 | Excel | 1 | 09-24-2010 08:51 AM |
Excel slow when connected with network and switching off server | viswaforu | Excel | 0 | 07-06-2010 09:30 PM |