Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2012
    Posts
    23
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Personal.xlsb new recorded macro is not available in other workbooks

    I have been using the personal.xlsb file to hold several macros that are used in various files when download for our online database. Today I created a new macro assigned to persoanl.xlsb and it contains references to the the downloaded file and the macro will not work in a new downloaded file. I double checked the that marco was in the personal.xlsb, and made sure that the xlsb file is open.

    I am in a pinch, does anyone have an ideas as to what is going on? Could there be limit to how many macros can be in the personal.xlsb file? I do not not enough about programming to change the code to allow it to be used in other workbooks.

    Thanks in advance for your assistance.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,895
    Thanks
    0
    Thanked 85 Times in 81 Posts
    What do you mean by "it contains references to the the downloaded file"?
    Regards,
    Rory
    Microsoft MVP - Excel.

  3. #3
    New Lounger
    Join Date
    Apr 2012
    Posts
    23
    Thanks
    3
    Thanked 0 Times in 0 Posts
    We have to download data from an online database. I then run that data through macros to prepare the data for use in Access. I found that my XLSTART file was accumulating the download files I was trying to record the macro in. Once I remove those, I was able to record the macro.

Posting Permissions

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