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).
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.
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!
Rob www.hifi-remote.com Please don't PM me with remote questions, post them in the forums so all the experts can help!
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.
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.
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).
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.
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.)
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.
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.
