+ Reply to Thread
Results 1 to 2 of 2

Macro in file works the first time, but not second time I open file

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Hartland, WI
    MS-Off Ver
    Excel 2013 Professional Plus
    Posts
    73

    Macro in file works the first time, but not second time I open file

    The file below is from an add-in I have called Geodesix. It is a mapping/geocoding program in Excel. It works great the first time I downloaded it, but every time I open it now, any macro I run says: object reference not set to an instance of an object. Also, when I copy all of the macros to another workbook, it works again for that first time, but then when I save/close and reopen, it has that same error, and I cannot figure out why. Any ideas?


    Copy of GeodesixVBA.xlsm
    Last edited by gillyr7; 06-19-2014 at 08:40 AM.

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Macro in file works the first time, but not second time I open file

    The attached sheet appears to be a test programme for Geodesix. All the buttons on this (at least the ones I tried) end up trying referring to CallGeodesix which in turn formats the parameters and call Geodesix.
    This test does not have the module Geodesix. This is presumaboboly loaded from either an addin or library which you haven't included


    click on the * Add Reputation if this was useful or entertaining.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 05-18-2012, 04:42 AM
  2. Open Excel file and run macro at set time
    By KevinThomas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2011, 04:45 PM
  3. Open Excel file and run macro at set time
    By KevinThomas in forum Excel General
    Replies: 1
    Last Post: 10-17-2011, 12:30 PM
  4. Macro needs to run each time I open the file
    By barksmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2008, 09:14 AM
  5. Replies: 1
    Last Post: 02-06-2006, 08:25 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1