Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weirdest Program Bug Ever ! Can anyone figure this out ??
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weirdest Program Bug Ever ! Can anyone figure this out ??
Look in your VBA help at ReDim and Redim Preserve.
RBS "Dan Thompson" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weirdest Program Bug Ever ! Can anyone figure this out ??
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 "Dan Thompson" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weirdest Program Bug Ever ! Can anyone figure this out ??
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 "Rick Rothstein (MVP - VB)" wrote: 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 "Dan Thompson" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weirdest Program Bug Ever ! Can anyone figure this out ??
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 "Dan Thompson" wrote in message ... 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 "Rick Rothstein (MVP - VB)" wrote: 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 "Dan Thompson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't figure this out... | Excel Discussion (Misc queries) | |||
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
Can't figure out | Excel Worksheet Functions | |||
merging excel program with tdc finance program | Excel Programming |