How to update an Excel file in Start before being opened by Excel

[gtaborda]

Hi

i have an excel sheet which opens at Start Up of Excel.
it is located in the START directory.

However this file is constantly being updated with new functions, etc

Currently we copy the new sheet manually in each PC.

I would like to, when opening Excel, BEFORE the sheet is opened by Excel, go and check in the server if there is a new version, if so, then replace it. Then open it.

I assume I can do this by having another sheet in START, which does the copying, however I am not sure in which order the sheets in START run...and whether it would work.

Perhaps there is a better way...

Thanks in advance

 

[SkipVought]

Hi,

"... we copy the new sheet manually in each PC...."

Sheet? Don't you mean WORKBOOK? If not, what Do you mean?

"...this file is constantly being updated with new functions..,"

How is this happening? Is there some program that is running in the background, poking functions into your workbook, unannounced? Please explain.

YOU understand what is happening, but you have not communicated very well to us, who know nothing about the process in your environment.



Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[gtaborda]

oK, sorry, I have not explained myslelf properly.

I meant we copy the WORKBOOK Manually everytime there is any type of changes to it. Lets call the file Personal2.xls

What I meant by "functions" is that we might add new "features" to the tool, so it needs to be copied again to everyone so they get the latest workbook (which opens up automatically when Excel is opened, same as Personal.xls file)

I would like copy automatically the Personal2.xls file to Start directory from somewhere in the server.

 

[SkipVought]

"I would like copy automatically the Personal2.xls file to Start directory ..."

automatically, based on what event or criteria?

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[AnotherHiggins]

Consider creating an addin instead of just a workbook full of functions.

Here are two good sites to help explain how it works:

http://www.ozgrid.com/VBA/excel-add-in-create.htm

http://j-walk.com/ss/excel/tips/tip53.htm

That second one (J-Walk) actually has a free file you can download that is already set up to help you design custom drop-down menus that sit up top alongside File, Edit, Tools and Help.

Once you've completed that, our own combo has posted a method of rolling out addins.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Gavona]

How about:
Store the file on the network, read only.
Have a macro in everyone's Personal.xls that opens the networked file - maybe driven by the On_Open event.



Gavin