LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open 2000 file attachments in Excel 2000 Judy[_2_] Excel Discussion (Misc queries) 2 September 20th 07 10:20 PM
I cannot edit cell format in Excel 2000 (Part of office 2000)! Brett Excel Discussion (Misc queries) 1 April 12th 06 05:58 PM
Using Excel 2000 as Data source for Word 2000 document Malcolm Agingwell Excel Discussion (Misc queries) 2 June 21st 05 09:28 AM
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file DCheslock Excel Discussion (Misc queries) 1 May 5th 05 10:46 PM
Excel Programs developed in Office 2000 on Windows 2000 Trooper Excel Discussion (Misc queries) 4 March 12th 05 11:09 PM


All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"