Auto running macros on a network

[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

 

[Bob Phillips]

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)

 

[Tom Ogilvy]

If you put a copy of your personal.xls on a network drive, you can open it
like any other workbook.

 

[aah-boy]

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

 

[Tom Ogilvy]

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.

 

[aah-boy]

On Sat, 1 Nov 2003 18:57:15 -0500, "Tom Ogilvy" <[email protected]>
wrote:

Tom,

Thanks for the advice. I will try it tomorrow.

Regards,
Dave