Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 vs. XP
I wrote a fairly complicated workbook with a substantial amount of VBA
in it. I tested it extensively on Excel XP and found no issues. I recently put it on a machine that has Excel 2000 and hand numerous errors. I tried to save the workbook as an Excel 2000.xls file (which incidently made the file balloon from 600K to over 1200) and I still had the same errors. I didn't think that would work, however, I still need a work around. Is there an update of some sort I could include with the release so that I could gurantee compatibility? The errors seem really arbitrary, I can't really include all of them but here is an example: (doesn't like the part in the **) ActiveChart.ApplyDataLabels AutoText:=False, LegendKey:=False, _ HasLeaderLines:=False, *ShowSeriesName:=False,* ShowCategoryName:=False, _ ShowValue:=True, ShowPercentage:=False, ShowBubbleSize:=False Thanks, -Joel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 vs. XP
Just to Add, XP (xl2002) and xl2000 use the same file format, so there is no
unique xl2000 file format you can save to. I suspect you used the xl5/95 and xl97/2000/2002 combined file format which actually makes two copies of the file contained in one compound file (and would double the file size). As Keepitcool advised, you probably are using arguments added in xl2002 that are not recognized in xl2000 and which raise errors. You will need to remove these arguments to get it to run in xl2000. In your example, ApplyDataLables - here are the arguments for this method in xl2000 taken from Excel VBA help: expression.ApplyDataLabels(Type, LegendKey, AutoText, HasLeaderLines) Note that all these arguments were apparently added in xl2002 ShowSeriesName ShowCategoryName ShowValue ShowPercentage ShowBubbleSize and would not be recognized in xl2000 - thus raising an error. -- Regards, Tom Ogilvy "J. Vandenberg" wrote in message om... I wrote a fairly complicated workbook with a substantial amount of VBA in it. I tested it extensively on Excel XP and found no issues. I recently put it on a machine that has Excel 2000 and hand numerous errors. I tried to save the workbook as an Excel 2000.xls file (which incidently made the file balloon from 600K to over 1200) and I still had the same errors. I didn't think that would work, however, I still need a work around. Is there an update of some sort I could include with the release so that I could gurantee compatibility? The errors seem really arbitrary, I can't really include all of them but here is an example: (doesn't like the part in the **) ActiveChart.ApplyDataLabels AutoText:=False, LegendKey:=False, _ HasLeaderLines:=False, *ShowSeriesName:=False,* ShowCategoryName:=False, _ ShowValue:=True, ShowPercentage:=False, ShowBubbleSize:=False Thanks, -Joel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open 2000 file attachments in Excel 2000 | Excel Discussion (Misc queries) | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) |