Microsoft Excel - Excel and VB Code Question

I have a workbook that was created in Excel 2000 and being used by users running both 2000 and 2007.  I have 2 problems I've encountered:

1 - I use VB to autoinvoke a SaveAs command which works fine and the documents can be reopened by the 2007 users.  However, when opened by the 2000 users, it is not recognizable format and is full of junk data.  I have already tried setting the "Save File As" in 2007 to be the 97 - 2003 format, but this has not worked.  Any help on how to fix this when using VB code?

 2 - I have a cell of data (text) that is hidden and seems to have a character maximum limit when viewed with the 2000 version, but not the 2007 version.  It's not that long, so seems to me there must be a setting somewhere in 2000 that I can set, but have not found it yet.  Any help?!  When the cell is displayed using 2000, it shows #VALUE! even though the content of the cell is in tact.

Thanks in advance for your help!