LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel 2002 VBA macro deployment troubles

Hi,
I have created a spreadsheet with various bits of vba code, and attached
each macro to a custom menu bar, but i have problem when i deploy it to the
network for my users.
on my machine it works fine, when its copied to the network, i get an error
when running the macros "A document with the same name ...... is already
open. you can not open two document .. etc"

the main question is what method should i use to deploy a simple
spreadsheet, for use with 30 employees, 1 person will be entering data, the
rest as read-only.
i don't want to put macro stuff in the personel.xls , and the spreadsheets
location will not be hard coded, as it may change.

i just want to include the code in the sheet, all self contained.

thanks
 
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
Excel macro deployment bk1234 Excel Discussion (Misc queries) 0 April 29th 10 07:51 PM
Customized Toolbar Deployment for Excel 2002 morgan Setting up and Configuration of Excel 3 September 22nd 06 02:56 PM
Macro Troubles mastermind Excel Programming 1 August 12th 06 07:41 PM
macro deployment - References DLL issue [email protected] Excel Programming 7 June 2nd 06 10:44 AM
Macro Troubles DR Excel Programming 1 February 15th 06 04:26 PM


All times are GMT +1. The time now is 06:08 PM.

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"