| View previous topic :: View next topic |
| Author |
Message |
Mark Pierson
Expert
Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA
|
 Posted: Wed Dec 03, 2003 10:03 pm Post subject: Re: Just received cable |
 |
|
| 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. 
| Quote: | | 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 |
|
| Back to top |
|
 |
TommyB
Joined: 02 Nov 2003
Posts: 9
|
| Posted: Wed Dec 03, 2003 10:44 pm Post subject: Re: Just received cable |
|
|
| 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:
| Quote: | | 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. |
|
| Back to top |
|
|
The Robman
Site Owner
Joined: 01 Aug 2003
Posts: 21238
Location: Chicago, IL
|
| Posted: Wed Dec 03, 2003 11:00 pm Post subject: Re: Just received cable |
|
|
| 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! 
_________________
Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help! |
|
| Back to top |
|
|
TommyB
Joined: 02 Nov 2003
Posts: 9
|
| Posted: Wed Dec 03, 2003 11:04 pm Post subject: |
|
|
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. |
|
| Back to top |
|
|
mr_d_p_gumby
Expert
Joined: 03 Aug 2003
Posts: 1370
Location: Newbury Park, CA
|
| Posted: Thu Dec 04, 2003 2:20 am Post subject: |
|
|
| 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.
_________________
Mike England |
|
| Back to top |
|
|
Mark Pierson
Expert
Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA
|
| Posted: Thu Dec 04, 2003 6:38 am Post subject: |
|
|
| 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.
| Quote: | | 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 |
|
| Back to top |
|
|
Mark Pierson
Expert
Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA
|
| Posted: Thu Dec 04, 2003 7:15 am Post subject: |
|
|
| 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.
_________________
Mark |
|
| Back to top |
|
|
TommyB
Joined: 02 Nov 2003
Posts: 9
|
| Posted: Thu Dec 04, 2003 8:49 am Post subject: |
|
|
| 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. |
|
| Back to top |
|
|
Mark Pierson
Expert
Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA
|
| Posted: Thu Dec 04, 2003 10:08 am Post subject: |
|
|
| 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)?
_________________
Mark |
|
| Back to top |
|
|
mr_d_p_gumby
Expert
Joined: 03 Aug 2003
Posts: 1370
Location: Newbury Park, CA
|
| Posted: Thu Dec 04, 2003 11:28 am Post subject: |
|
|
| 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.)
_________________
Mike England |
|
| Back to top |
|
|
Mark Pierson
Expert
Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA
|
| Posted: Thu Dec 04, 2003 6:38 pm Post subject: |
|
|
| 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.
_________________
Mark |
|
| Back to top |
|
|
Mark Pierson
Expert
Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA
|
| Posted: Thu Dec 04, 2003 6:40 pm Post subject: |
|
|
| 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 
_________________
Mark |
|
| Back to top |
|
|
Mark Pierson
Expert
Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA
|
| Posted: Thu Dec 04, 2003 7:51 pm Post subject: |
|
|
| 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.
_________________
Mark |
|
| Back to top |
|
|
Mark Pierson
Expert
Joined: 03 Aug 2003
Posts: 3017
Location: Connecticut, USA
|
| Posted: Thu Dec 04, 2003 8:29 pm Post subject: |
|
|
FYI, I split the original topic, and moved the KM errors portion here to the Software forum.
_________________
Mark |
|
| Back to top |
|
|
mr_d_p_gumby
Expert
Joined: 03 Aug 2003
Posts: 1370
Location: Newbury Park, CA
|
| Posted: Fri Dec 05, 2003 3:20 am Post subject: |
|
|
| 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: | | kmVersion = ThisWorkbook.Worksheets("Setup").Range("KM_Version").Value |
This is when I use Excel 97 on W2K.
_________________
Mike England |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
File Section
Wiki
