I'm trying to create an auto_open macro which saves the workbook being
opened into a certain directory if it hasn't already been saved. I
placed the code in the Workbook_open event in book.xlt and this works
on Workbooks created after I added the code but doesn't run on any
workbooks created before.

I've tried adding the auto_open code in an addin but this only seems
to run when Excel starts up (and the addin opened I guess).

I'm new to Excel programming (experienced in Word programming but
that's it). I've searched the groups and found a lot on auto_open
macros but can't get any to work ... Any help greatly appreciated!!

Cheers,
Tammy