Page 1 of 2
Re: Just received cable
Posted: Wed Dec 03, 2003 9:03 pm
by Mark Pierson
TommyB wrote:I was having problems with the latest version of KM - getting errors in the code...
v8.02? Can you be more specific? What kind of errors? Were you trying to use a file by loading it (if so what file)? I can't fix it if I don't know what's broke.
I am pretty good with Excel vb, but that code was pretty advanced so I didn't really get too far into it
There is absolutely
NO VBA code used in any of KM's calculations!
It's all done with smoke and mirrors (and a whole bunch of complicated formulas).
Re: Just received cable
Posted: Wed Dec 03, 2003 9:44 pm
by TommyB
Mark Pierson wrote: There is absolutely
NO VBA code used in any of KM's calculations!
It's all done with smoke and mirrors (and a whole bunch of complicated formulas).
Sure looks like there is quite a bit of code in there to me. I'm getting the first error on an open event...the error is:
Run time error '40036' - Application-defined or object defined error
This is happening on line 177 of the code (on Sheet 1)
I get the same error again further into the code. This time on line 4 of Sheet 51.
*edit - I am not loading anything into the program - I'm getting the errors on start-up.
Re: Just received cable
Posted: Wed Dec 03, 2003 10:00 pm
by The Robman
TommyB wrote:Mark Pierson wrote: There is absolutely
NO VBA code used in any of KM's calculations!
It's all done with smoke and mirrors (and a whole bunch of complicated formulas).
Sure looks like there is quite a bit of code in there to me.
Hey Tommy, you see that little yellow circle with a winking eye in it, the one followed by the "smoke and mirrors" bit, I think that indicates that Mark was joking!
Posted: Wed Dec 03, 2003 10:04 pm
by TommyB
I hope I wasn't comming accross rude in my reply...just wanted Mark to know that I wasn't seeing things
So, am i the only one having problems with this version of KM...the errors do not indicate that it is a local problem on my machine.
Posted: Thu Dec 04, 2003 1:20 am
by mr_d_p_gumby
TommyB wrote:So, am i the only one having problems with this version of KM...the errors do not indicate that it is a local problem on my machine.
Well, when Mark said it doesn't use VBA, he was mostly correct. VBA is used to load and save the .txt files, and initialize a few things when KM starts up. It might help Mark to know what version of Excel you are using, and your OS version.
Posted: Thu Dec 04, 2003 5:38 am
by Mark Pierson
mr_d_p_gumby wrote:Well, when Mark said it doesn't use VBA, he was mostly correct. VBA is used to load and save the .txt files, and initialize a few things when KM starts up.
Well... I still stand by my statement the no VBA code is used to calculate any of KM's data. Is it used basically to drive the interface.
It might help Mark to know what version of Excel you are using, and your OS version.
Ya think
I tested 8.02 on XL XP and XL 2k (both running Win98SE). I have not encountered any errors. I can't really dig into the specific error messages from Tommy until I get home from work tonight.
Posted: Thu Dec 04, 2003 6:15 am
by Mark Pierson
Mark Pierson wrote:I tested 8.02 on XL XP and XL 2k (both running Win98SE).
I just tired it on XL 2k under WinXP without errors as well. A quick search of the MSKB didn't offer any clues to the error message Tommy received (Run time error '40036' - Application-defined or object defined error).
As I said, I'll try to dig into it tonight.
Posted: Thu Dec 04, 2003 7:49 am
by TommyB
I'm using Excel 97. We're on 2K here at work and everything loaded fine, so that's probably the problem. I'll look into it a little bit more tonight when I get home.
Posted: Thu Dec 04, 2003 9:08 am
by Mark Pierson
TommyB wrote:I'm using Excel 97.
Ah hah!... the old XL97.
I think I know what the problem is. Can you confirm the KM version you're using (8.01 or 8.02)?
Posted: Thu Dec 04, 2003 10:28 am
by mr_d_p_gumby
Mark Pierson wrote:mr_d_p_gumby wrote:Well, when Mark said it doesn't use VBA, he was mostly correct. VBA is used to load and save the .txt files, and initialize a few things when KM starts up.
Well... I still stand by my statement the no VBA code is used to calculate any of KM's data. Is it used basically to drive the interface.
And I stand by your statement also... 8)
(You needed to read "mostly correct" above with a Billy Crystal voice, as in "mostly dead" from Princess Bride.)
Posted: Thu Dec 04, 2003 5:38 pm
by Mark Pierson
TommyB wrote:I am pretty good with Excel vb
Since you know you're way around VBA, on your XL97 system, can you fire up Excel, load the VBA Editor, go to VBA help, and search for "DataObject"?
I have a feeling that this object doesn't exist in XL97, but can't find a definitive resource (including MSKB and MSDN). If that's the case, then I know what the problem is and can hopefully do some sort of work-around for XL97 users.
Posted: Thu Dec 04, 2003 5:40 pm
by Mark Pierson
mr_d_p_gumby wrote:And I stand by your statement also...
Thank you for your support, Mike.
Now, can you STOP standing on my toes
Posted: Thu Dec 04, 2003 6:51 pm
by Mark Pierson
Mark Pierson wrote:I have a feeling that this object doesn't exist in XL97, but can't find a definitive resource (including MSKB and MSDN).
The only thing I hate worse than quoting myself is Microsoft.
Why can't they ever make anything easy? After some digging, I have found that the DataObject DOES apparently exist in XL97. Of course, that doesn't help me because it's what I thought was causing the error.
Back to the drawing board.
Posted: Thu Dec 04, 2003 7:29 pm
by Mark Pierson
FYI, I split the original topic, and moved the KM errors portion here to the Software forum.
Posted: Fri Dec 05, 2003 2:20 am
by mr_d_p_gumby
Mark Pierson wrote:Now, can you STOP standing on my toes
OK, but only long enough to make v8.02 crash on my system too.
Seriously, it's giving the error on this line in the Workbook.Open procedure:
Code: Select all
kmVersion = ThisWorkbook.Worksheets("Setup").Range("KM_Version").Value
This is when I use Excel 97 on W2K.