Microsoft Excel Excel and VB Code Question

View Other Microsoft Excel Posts Ask New Question Ask New Question With Power Editor

Excel and VB Code Question

Kate Burdge posted at Thursday, November 13, 2008 1: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!

Reply Reply Using Power Editor

	Rank	Winnings	Points
November	0	$0.00	0
October	0	$0.00	0

READ THIS LINK

C_A P replied to Kate Burdge on Tuesday, November 18, 2008 6: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.

Reply Reply Using Power Editor

	Rank	Winnings	Points
November	0	$0.00	0
October	0	$0.00	0