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: 1
Default Excel 2003 disliking an old sheet's basic commands


Hi all

I recently dug up a 2-year-old spreadsheet script of mine, writte
originally in VBA for XL2000. It works fine if I run it under XL2000
but as soon as I try it with the next version of Excel, XL2003,
peculiar error appears.

After a certain point in the code, any VB calls to the spreadshee
fail. this includes all cell reading, writing, chart selection the lot
Any interaction, it seems, returns the 'Application-defined o
Object-defined' error. The point at which this error starts to appea
is when an add-in object that issues callbacks is activated - th
errors seem to stop when this object is deactived (I say 'activation'
this is when the object is set to listen for an external trigger o
sorts. I'm a little hazy on how it works tbh).

A slightly vague question, perhaps, but I'm told this is a common issu
(that said, it's not appearing in my searches). I would blame the add-i
object if it weren't for the fact this script works perfectly in XL2000
Any ideas

--
F*S
-----------------------------------------------------------------------
F*SH's Profile: http://www.excelforum.com/member.php...fo&userid=3635
View this thread: http://www.excelforum.com/showthread.php?threadid=56518

 
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
Why 39 sec. delay for simple commands, Excel 2003? Thanks! fmes Excel Discussion (Misc queries) 1 December 19th 09 02:10 PM
how to use my Excel 2003 DTF commands Ravi Manian Excel Worksheet Functions 1 July 11th 08 09:02 AM
use lotus 1-2-3 commands in excel 2003 Rik J Excel Worksheet Functions 3 February 10th 06 05:36 PM
Visual Basic commands for email David Overington Excel Programming 1 February 9th 05 02:39 AM
xlm solver commands in excel 2003 aspo Excel Programming 2 November 16th 04 03:29 PM


All times are GMT +1. The time now is 09:01 AM.

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

About Us

"It's about Microsoft Excel"