+ Reply to Thread
Results 1 to 5 of 5

More Macro / Addin Troubles

  1. #1
    Registered User
    Join Date
    06-04-2008
    Posts
    14

    More Macro / Addin Troubles

    I want to create an addon so that I can distribute a macro to others. I'm doing the following:

    1) I open a brand new work book, push alt + f11 to go to VB editor, and insert my code in a new module. I compile it.
    2) I insert the following code in the "ThisWorkBook" code section and compile it. The point of this code is to add a tool bar to run my macro when a worksheet opens, and delete it when it closes:

    Please Login or Register  to view this content.
    3) I save it as an addin and place it in the addin folder.

    When I try to use it in another work book, the toolbar opens up fine, but when I go to click on the macro I get a weird message:

    'countbinstoolbar.xls' could not be found. Check the spelling of the file name and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that file has not been moved, removed or deleted.'

    I should say that 'countbinstoolbar.xls' isn't even the name of the addin (countbins) and was a file that I created a couple of hours ago when I was playing with that I eventually deleted. So I have no idea why that's on there.

    When I try to open this on my friends computer, nothing happens, the toolbar doesn't even get added. Does anyone know what I could be doing wrong? We're both using excel 2003 btw.

    Kiss
    Last edited by kissfrito; 06-04-2008 at 02:02 PM.

  2. #2
    Forum Contributor
    Join Date
    04-30-2008
    Posts
    105
    I'd hate to sound like a jerk but this is a cross post. The Excel help community takes this seriously (as I learned the hard way). I figure this is completely incidental (as it was in my case), but if people find out about this, you'll most likely receive no help, get your thread locked/deleted, and/or be banned. Theres good reason for this if you think about it. All you have to do when you do cross post is note (on all forums this questions is on) that the question can also be found in other forums and post links to that thread. This way, should someone invest time in figuring out your solution, they know that it already hasn't been addressed in other forums already and that they wasted their time.

    The question is also here:
    http://www.mrexcel.com/forum/showthread.php?t=323109

    Also, you may want to try to use Tools-References command in VBE.
    Last edited by fecurtis; 06-04-2008 at 02:29 PM.

  3. #3
    Registered User
    Join Date
    06-04-2008
    Posts
    14
    alright sorry about that.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    the Toolbar code should be in the addin
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    06-04-2008
    Posts
    14
    the toolbar code is in the addin.

    actually the problem that I had just mentioned I was getting because I was clicking on an old tool bar that had the same name as the one the addin is trying to create. My new problem is simply that the toolbar is not getting added.

+ 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. Macro stop working and create errors
    By ephendi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2008, 06:16 PM
  2. country finder lookup macro
    By theghost in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2007, 10:41 PM
  3. Make Called Macro End the First Macro
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2007, 11:38 AM
  4. Help with a Macro (MS Word)
    By Push Latency in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2006, 01:37 PM

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