PC Review


Reply
Thread Tools Rate Thread

2008->2003 incompatibility

 
 
aarongraham@mac.com
Guest
Posts: n/a
 
      21st Jan 2008
I have multiple workbooks that have the following code:{some clean up
done so it may not be perfect}
Dim theRect As Shape
Dim curSheet As Worksheet
Set curSheet = ActiveSheet
Application.ScreenUpdating = False
For Each theRect In ActiveSheet.Shapes
If (theRect.Line.ForeColor.SchemeColor = 12) Then
theRect.Line.ForeColor.SchemeColor = 9
End If
Next


When that code runs on XP/Office 2003 in a workbook that has been
saved on Vista/Office 2008, I get runtime error 70, Permission denied
when trying to access the schemecolor in the if statement. This code
has been in the workbooks for quite a few years, but they have been
recently updated(in other areas) to work correctly on Vista/Office
2008.

Weird thing is that if I debug and skip the execution of the if
statement, I can modify the schemecolor, and then can access the
schemecolor of that rect with out issue.

Has anyone else seen this?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
incompatibility between office XP and 2003 Analyze tool blocked Satish Microsoft Outlook Contacts 8 3rd Jul 2008 01:34 AM
Access 2002/2003 Incompatibility =?Utf-8?B?QmVuV2ViZXI=?= Microsoft Access 2 19th May 2006 07:24 PM
Word 2003 incompatibility =?Utf-8?B?cXVlc3Q3NjU=?= Microsoft Word Document Management 4 2nd Apr 2005 09:49 PM
VS .NET 2003 incompatibility with WinCE 5.0 Hans Skytt Steffensen Microsoft Dot NET Compact Framework 2 18th Nov 2004 11:25 PM
Version incompatibility on VS.NET 2002 vs 2003? Just Curious Microsoft Dot NET 1 13th Oct 2003 11:23 PM


Features
 

Advertising
 

Newsgroups
 


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