Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Run-time error 2147467259 80004005 automation error

This is a discussion on Run-time error 2147467259 80004005 automation error within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am using a variant of the calcpos application. When I open excel with the VBA code and run the ...

  1. #1
    ThomasB is offline Crime Analyst White Belt
    Join Date
    Feb 2007
    Posts
    3

    Angry Run-time error 2147467259 80004005 automation error

    I am using a variant of the calcpos application. When I open excel with the VBA code and run the program, I get the lat and long for a specific address. However when I run it again. I get a run-time error 2147467259 80004005 - automation error message. Oddly enough, if I select the code in VBA and copy and paste it back. I can run the program again and it works. It seems that the copy and paste is clearing out the buffer and replacing it with whatever I copy and that causes the program to work again - but only once. Any ideas on how to fix this?

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Run-time error 2147467259 80004005 automation error

    Hi,

    I don't know VBA, but I assume you have a debugger. Can you step trough the code to see the offending line ? And can you also see the value assigned to objects and variables ?

    I assume something is destroyed and not created again. Or something is not cleared where the values are not right the second time.

  3. #3
    ThomasB is offline Crime Analyst White Belt
    Join Date
    Feb 2007
    Posts
    3

    Thumbs up Re: Run-time error 2147467259 80004005 automation error

    Quote Originally Posted by Wilfried View Post
    Hi,

    I don't know VBA, but I assume you have a debugger. Can you step trough the code to see the offending line ? And can you also see the value assigned to objects and variables ?

    I assume something is destroyed and not created again. Or something is not cleared where the values are not right the second time.

    Thank You Wilfried for replying. I just fixed the problem by adding the following lines at the bottom of the function's code:

    Set locNorthPole = Nothing
    Set locSantaCruz = Nothing

    I had tried this earlier but had not set the right variables to nothing after each iteration.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Run time Error 16400
    By bdg in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 02-15-2007, 10:19 AM
  2. run-time error 16391 with MP control in vb6
    By cwrude in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-28-2006, 12:14 PM
  3. Run-time Error 16398 using Mappoint 2004 ocx
    By blueisland in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-13-2004, 12:59 AM
  4. Run-time error 'Method 'UpdateLink' object 'DataSet' failed
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-18-2003, 03:53 PM
  5. Error in VBA automation of MapPoint when PO BOX is found
    By JPeters in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-09-2003, 09:40 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96