macro with external script.

[kurt]

Hi all

Insted of having the macro in the Excelfile; I would like to put it on
the network.
It is easyer to maintain this than that each workbook has to be revised
from time to time.

The function should be like this:
On opening an excel spreadsheet the open macro starts

on workbook open()
get a script from p:\script.txt
execute this script
end

Does anyone have a solution

Regards
Kurt

 

[Norman Jones]

Hi Kurt,

Why not put the code in an addin file save it in a network folder?

That way all user's could access the required code and only one file would
require possible revision.