Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Waldorf, MD
    Posts
    18
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Problem with Excel 2003 toolbar buttons

    I had to get a new computer. The new and old PC have Windows 7 64 bit and Office 2003 Professional. I wrote a lot of VBA code for Excel macros in a separate Excel workbook and assigned them to various toolbar buttons. On my new PC, I moved the 'VBA' workbook to a secondary hard drive. I also transferred my xlb and personal.xls files to the corresponding folders on my C drive on the new computer. My problem is that when I click on a button which points to the VBA workbook file Excel tells me it cannot find it and displays the path to the C drive where it used to be. I customized the button to change the drive letter and tried again. The first time it worked okay. The second time I got the same error message and the path points to me C drive. I have tried putting a copy of the VBA workbook in the directory as it was before, per the path. However, I still get the macro not found message. Anyone have an idea about how I can fix this? Thanks.
    ---
    ----------------------------------------------------------

    The macro "C:\Dick\_VBA_Code\_VBACode Home\_VBA - Excel\White-Macros.xts'!sNavGoToEnd' cannot be found.


    When I open Excel, the button has this assigned link:
    'F:\Dick\_VBA_Code\_VBA Code Home\_VBA - Excel\White-Macros.xls'!sNavGoToEnd


    After clicking the button a second time, this is the assigned link value:
    'C:\Dick\_VBA_Code\_VBA Code Home\_VBA - Excel\White-Macros.xls'!sNavGoToEnd

  2. #2
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,078
    Thanks
    0
    Thanked 259 Times in 248 Posts
    I'm looking at Excel 2011 on my MacBook and see in Preferences where locations of files can be set. Maybe it's Options in the Windows version.

  3. The Following User Says Thank You to Berton For This Useful Post:

    bluegoose1776 (2015-05-11)

  4. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Waldorf, MD
    Posts
    18
    Thanks
    5
    Thanked 0 Times in 0 Posts
    I cannot find a option to set Preferences in Excel 2003. Thank you for the idea.

  5. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Is there any code in the macro workbook that creates or manipulates toolbar buttons?
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 483 Times in 460 Posts
    Hi bluegoose

    In Excel2003 you can set default file locations using the top-panel commandbar: Select Tools>Options
    ..and then selecting the tab named [General]
    ..look in the bottom section for Default File Location..

    zeddy

  7. The Following User Says Thank You to zeddy For This Useful Post:

    bluegoose1776 (2015-05-14)

  8. #6
    New Lounger
    Join Date
    Dec 2009
    Location
    Waldorf, MD
    Posts
    18
    Thanks
    5
    Thanked 0 Times in 0 Posts
    I looked, but did not find anything that related to the macro workbook.

  9. #7
    New Lounger
    Join Date
    Dec 2009
    Location
    Waldorf, MD
    Posts
    18
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Can someone explain why I have two copies of Excel11.xlb file in two different directories?
    C:\Users\Dick\AppData\Roaming\Microsoft\Excel\Exce l11.xlb
    C:\Users\Dick\AppData\Roaming\Microsoft\Excel\XLST ART\Excel11.xlb

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
  •