Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default share excel macros

I have built macros that work for files located on the network. How can I
copy or have my macros available for others to use at their workstations for
files located on the network?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default share excel macros

Create an add-in and distribute that to your users.

--
HTH

Bob Phillips

"Glen" wrote in message
...
I have built macros that work for files located on the network. How can I
copy or have my macros available for others to use at their workstations

for
files located on the network?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default share excel macros

How do I create an add-in for this purpose?


"Bob Phillips" wrote:

Create an add-in and distribute that to your users.

--
HTH

Bob Phillips

"Glen" wrote in message
...
I have built macros that work for files located on the network. How can I
copy or have my macros available for others to use at their workstations

for
files located on the network?




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default share excel macros

Essentially, all you do is put all your code in a new workbook, and then do
a SaveAs with a file type of xla (at the foot of the list). The xla file is
then installed (ToolsAdd-InsBrowse and find it).

--
HTH

Bob Phillips

"Glen" wrote in message
...
How do I create an add-in for this purpose?


"Bob Phillips" wrote:

Create an add-in and distribute that to your users.

--
HTH

Bob Phillips

"Glen" wrote in message
...
I have built macros that work for files located on the network. How

can I
copy or have my macros available for others to use at their

workstations
for
files located on the network?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I share a template in Excel Henry Setting up and Configuration of Excel 2 November 17th 08 06:34 PM
Share the same Excel document MGadAllah Excel Discussion (Misc queries) 2 April 14th 08 08:57 PM
share excel document Aew004 Excel Worksheet Functions 0 August 30th 05 05:26 PM
Use Share Feature in Excel thedeal Excel Worksheet Functions 0 March 17th 05 04:41 PM
How do I share macros? blaze57 Excel Discussion (Misc queries) 3 February 18th 05 01:36 AM


All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"