Excel Macros

[Mike]

I was wondering if there was a way to create a template
spreadsheet containings macros, that users can share on a
network drive, and import data into on a daily basis and
edit that data using the said macros?

Thanks

 

[Bob Phillips]

Why do you want to import them daily? Is it because they would change
regularly? If not, the best way is to create an addin, which can be
installed from a network. This would not need to be done daily, but could be
done whenever the macros change. You could even introduce versioning that
would stop them running if the master had changed.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)