Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Strange VBA Behaviour

Hi,

I am experiencing two really strange things in an Add-In I've created,
one additional note is that the following problems are only occurring
on a handful of machines out of about 100 where it has been
distributed.

First one is a simple setting a new instance of a class

Set myObj = New ClassName

If I do a F8 in debug mode on this line the whole of Excel closes and
does its auto restart, I have run this code on two machines side by
side and one works and other other doesn't.

The second problem is that a function calls from a module into a class
in not going into the function, it basically goes somewhere completely
different, into code that is not even being called. Same scenario as
above with both machines, one works and the other doesn't. I am
referencing some custom built COM dll's.

This is extremely wired behaviour and I have no idea why this could be
happening? Anybody have any thought?

Thanks, Rick

Reply
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
Strange if(***) behaviour? Excel 2003 - SPB Excel Discussion (Misc queries) 6 August 6th 06 05:34 PM
Automation behaviour - strange but very useful Robert Chapman[_3_] Excel Programming 2 April 11th 05 09:43 AM
Strange behaviour Edgar Thoemmes Excel Worksheet Functions 1 February 8th 05 03:20 PM
Strange behaviour in VBA Help Michael Singmin Excel Programming 4 June 4th 04 07:06 PM
strange behaviour Patrick Molloy Excel Programming 0 September 4th 03 07:51 AM


All times are GMT +1. The time now is 12:06 AM.

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"