I WAS going to title this post "Cross Species Intimate Relationships", but figured that was too obscure.

Here's the background for my problem:

Tonight my small group (the Finance group) is being upgraded from Excel 2003 to Excel 2010. So, we'll work in 2010, but our audience will still be on 2003 for the next 5-6 months.

Every day I run a long routine to make files ready for my audience. I have a workbook full of macros (BudMonTool.xls) that's opened by Windows Scheduled Tasks. BudMonTool opens a base file (BudMonBase.xls) that I use as a template for the workbooks I'm creating; BudMonBase also has lots of macros BudMonBase gets packed full of information from about 20 other workbooks that are opened and closed during the course of events (all of these are 2003 workbooks now, but MAY get converted to 2010, as they're our (Finance) source books). During the course of events, BudMonBase gets saved 20 times as a 2003 .xls file, with 20 different filenames, slightly different information in each one.

My question is, how do I get Excel 2010 (my version) to save the files as Excel 2003 workbooks, and how do I handle my coding if any or all of my sourcebooks change to .xlsx or .xlsm formats? Also, since I'm working in 2010, would it benefit me to convert BudMonTool.xls to .xlsm? And since I'm using BudMonBase basically as a template, would it help or hurt to upgrade it to .xlsm, knowing it will need to be saved as a 2003 .xls workbook?

Thanks in advance for any help you can provide. I'm very concerned going into this upgrade, and IT hasn't offered us the option of having both 2003 and 2010 on the same machine, so I've got to hit the ground running tomorrow morning.

Thanks,
John