Microsoft Excel - Excel and VB Code Question

Asked By Kate Burdge
13-Nov-08 01:40 PM

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!

READ THIS LINK  READ THIS LINK

18-Nov-08 06:38 AM
If you want to edit the workbooks, then you'll need xl2007.

If you want to view the workbooks, you can download the free compatibility
pack:
http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

The compatibility pack will allow you to edit the workbook.
Create New Account
help
Enregistrer dbf sous excel 2007 Excel Bonjour la Communaut??, Comment r??ussir ?? enregistrer un format dbf sous excel 2007? Merci pour vos conseils Bernie Excel - French Discussions Microsoft Excel (1) Excel 2003 (1) Excel 2007 (1) DBASE (1) Enregistrer (1) Communaut (1) Conseils (1
What are the differences between excel 2000 & excel 2007? Excel We're trying to decide if it would be beneficial to upgrade from excel 2000 to excel 2007. What are the differences between excel 2000 & excel 2007? Excel Miscellaneous Discussions Microsoft Excel (1) Excel 2007 (1) BA597438D5D2 (1) Previews
Conflict with Valid Range Reference Error in Microsoft Excel 2007 Excel Hi, While converting the Macros enabled Microsoft Excel 2003 to Microsoft Excel 2007 format, I am getting the following Conflict with Valid Range Reference Error. After clicking
Deleating All Selected Data Excel 2007 Excel Excel 2007 (What worked for Excel 2003 makes 2007 crash). I have run Microsoft Office Diagnostics and it can not identify any problems) When I try to delete data
SQL plus de Inclure les noms de champ dans SQL EXcel 2007 Excel Bonjour, Nous venons de miger de Microsoft Excel 2003 vers Microsoft Excel 2007. Dans la version Excel 2003, on avait avec clic droit sur une plage de donnÃ