Auto running macros on a network

  • Thread starter Thread starter aah-boy
  • Start date Start date
A

aah-boy

Hi all,

Can someone please help me out here?

I'm on a NT network at work and I use macros with my peronal.xls file
- which automatically loads up - this is on the C: drive.

Occasionally we have to 'hot desk' - switching desks for different
shift working. Is there a way I can use my network logon (or something
different) to auto load my own worksheet whatever machine I use?

I must add, we do have access to the 'global' network drives - if that
helps.

Thanks,
Dave
 
Dave,

How about converting it to an add-in, store it on the global drive, and
install it in Excel from there?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
If you put a copy of your personal.xls on a network drive, you can open it
like any other workbook.
 
Thanks for the replies,

What happens in my daily (monotonous) life - we get emails, each email
has a excel attachment - I dbl click on the attachment and I run my
macro. In this case my macro reformats the spreadsheet and formats an
email ready for sending and then closes excel down - I then enter a
code into the email an d send it to the customer.

If the answers given will work in this situation then just ignore me -
I will have to try when I get into work on Monday.

Thanks,
Dave
 
If you go into tools=>Options and select general tab and specify an
alternate startup directory that is on a path that is common to all
workstations (a network drive), then put your personal.xls in that location
and remove it from any other location, then I believe that will work.
 
On Sat, 1 Nov 2003 18:57:15 -0500, "Tom Ogilvy" <twogilvy@msn.com>
wrote:

Tom,

Thanks for the advice. I will try it tomorrow.

Regards,
Dave
 
Back
Top