Excel Macros

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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)
 
Back
Top