ThisWorkbook refers to the workbook containing the code, obviating the need
to include a hard coded name.

--
Regards,
Tom Ogilvy

Bull Splat wrote in message
om...
Thanks to all that responded. OpenOffice did open the file, but it
couldn't replicate the extensive formatting, chart options, etc.

I had been saving this file frequently with new file names, but I
stopped doing that when the macros wouldn't work across multiple
workbooks (I had to go into the each macro and search and replace the
name of the workbook to get the macro to run). I'm certain that this
is due to a novice understanding of the programming side of Excel, and
I've since started saving all of my Macros in a macro worksheet where
they're available to all worksheets, but I still run into minor
problems as far as workbook names.

So, the good news is "I saved a Ton of Money on my Insurance", whoops,
sorry, the good news is all of the macros I created are still
available in the macro worksheet, and I've lost only a day of work as
far as getting this project delivered.

Thanks again to all, this forum is great!