The workbook containing the macro would have to be open to run the macro.

You may want to look at a scheduler program (some versions of windows have
this built in, but there are lots of shareware programs that do it, too
(www.shareware.com).)

Then that windows scheduler program can start your file(s) (data and macro) and
the workbook could have an auto_open macro that runs when the workbook opens.

Karon wrote:

is it possible to have a macro run on it's own on a daily
basis without having to open the spreadsheet?

--

Dave Peterson