Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2012, 11:53 AM
ibrahimaa ibrahimaa is offline Share Excel Add-In In A Network Environment? Windows Vista Share Excel Add-In In A Network Environment? Office 2007
Advanced Beginner
Share Excel Add-In In A Network Environment?
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Default Share Excel Add-In In A Network Environment?

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.
Reply With Quote
  #2  
Old 04-27-2012, 04:28 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Share Excel Add-In In A Network Environment? Windows 7 32bit Share Excel Add-In In A Network Environment? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 04-30-2012, 03:01 AM
ibrahimaa ibrahimaa is offline Share Excel Add-In In A Network Environment? Windows Vista Share Excel Add-In In A Network Environment? Office 2007
Advanced Beginner
Share Excel Add-In In A Network Environment?
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 04-30-2012, 04:38 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Share Excel Add-In In A Network Environment? Windows 7 32bit Share Excel Add-In In A Network Environment? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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?
Reply With Quote
  #5  
Old 04-30-2012, 04:41 AM
ibrahimaa ibrahimaa is offline Share Excel Add-In In A Network Environment? Windows Vista Share Excel Add-In In A Network Environment? Office 2007
Advanced Beginner
Share Excel Add-In In A Network Environment?
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Default

The answer is: To have it saved communally in a shared network folder.
Reply With Quote
  #6  
Old 04-30-2012, 05:30 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Share Excel Add-In In A Network Environment? Windows 7 32bit Share Excel Add-In In A Network Environment? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Okay, so
  • First you need to save the add-in into the shared network folder.
  • Then I suggest you right click > properties and make the file read-only. This means that if you want to make an update to the add-in later on, it will not be locked by your colleagues.
  • Once the file is saved your colleagues need to open Excel > Office button > addins > Manage Excel-Addins > GO > Browse
  • In the pop-up window they then need to browse to the shared network folder and double click on the addin.
  • They will get a prompt asking them if they want to copy the add-in to their local AddIns folder. They should choose NO. If they choose YES then it would mean that future updates would be more difficult to give to them because their version of the add-in would be saved locally.
  • Once they click on OK your add-in and its macros should be available to them (it should be ticked in their add-in list).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Share Excel Add-In In A Network Environment? Microsoft Project 2010 taking up to 10mins to open file from network share. 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
Share Excel Add-In In A Network Environment? Access to an Office 2010 Excel file over network lohith.korp Office 2 09-27-2010 08:32 AM
Share Excel Add-In In A Network Environment? How to synchronize Excel Sheet over Network 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft