Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / April 2008

Tip: Looking for answers? Try searching our database.

Weirdest Program Bug Ever ! Can anyone figure this out ??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dan Thompson - 08 Apr 2008 22:49 GMT
Ok I don't know what is up with this but this has to be the most strange
program bug ever. I have wrote a program in excel VBA that goes out to a
website grabs data then parses it and puts it into a spread sheet. I have
used an Array to store the data it gathered from the website and than put it
into the appropriate columns and rows.
I designed my code to be modular so if I want to add  new data sets ie more
columns for more new data all I have to do is add more elements to my
existing array. My Array had 14 elements to it and I have now added two more
elements and two more data columns where the data stored in the new elements
will be placed. Sounds fine right. Well here is the glitch when I added the
new elements to my array (and yes I did remember to RE DIM my Array to
include the new elements) and ran my program nothing happens with the new
elements it's like VBA is not seeing them or ignoring them completely. I get
no errors popping up when I run the code either. The weird thing is if I put
a Watch on my array and than run the code it runs exactly as it should. And
puts the new data from the new elements in my array exactly where it is
supposed to go. So What Gives ?? I am completely confused and frustrated
because it seems that the only way my program will run correctly is if I run
it in debug mode with a watch placed on the problem array.  The only thing I
can possibly figure is that maybe I am missing some Microsoft update for my
Excel VBA or somthing. I am running Excel 2003 just for your Info.  

ANYONE know what is going on why this is doing this ???

Dan Thompson
RB Smissaert - 09 Apr 2008 00:27 GMT
Look in your VBA help at ReDim and Redim Preserve.

RBS

> Ok I don't know what is up with this but this has to be the most strange
> program bug ever. I have wrote a program in excel VBA that goes out to a
[quoted text clipped - 32 lines]
>
> Dan Thompson
Rick Rothstein (MVP - VB) - 09 Apr 2008 06:24 GMT
And you thought keeping the code that is doing this hidden from us would in
some way be an aid to our figuring out what is wrong? <g>

Rick

> Ok I don't know what is up with this but this has to be the most strange
> program bug ever. I have wrote a program in excel VBA that goes out to a
[quoted text clipped - 32 lines]
>
> Dan Thompson
Dan Thompson - 11 Apr 2008 20:40 GMT
Well I would have posted the code but there is nothing wrong with the code I
already confirmed that.  However since I posted this I left my program for a
day or to and went back to it and ran it again and now it is working fine
without the watches being added when I run it.  Go figure huh.  So it seams
to work fine now and I have changed nothing since I posted this problem.  
Freak'en Microsoft Stuff is so Quarky somtimes.

Thanks Anyhow for those who replied to my post

Dan Thompson

> And you thought keeping the code that is doing this hidden from us would in
> some way be an aid to our figuring out what is wrong? <g>
[quoted text clipped - 37 lines]
> >
> > Dan Thompson
Rick Rothstein (MVP - VB) - 11 Apr 2008 20:55 GMT
The only reason I suggested we would need to see your code is it sounded
like you were describing a timing issue of some kind (perhaps you were using
the Shell command, calling a Timer, something else) and without seeing what
you were doing, there is virtually no way anyone could begin to guess what
to tell you. However, as everything is now working, the issue seems like it
was something other than your code. Maybe your disk defragged was running or
some other CPU hogging process, like an Anti-Virus download, was active
(which, I guess, would still have made it a timing issue).

Rick

> Well I would have posted the code but there is nothing wrong with the code
> I
[quoted text clipped - 63 lines]
>> >
>> > Dan Thompson
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.