Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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

All times are GMT -7. The time now is 03:45 AM.


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