macro RRS feed

  • Question

  •  I have 2 seperate workbooks that we use has our "templates" we have to copy and paste them to daily folders and use them for out data on a daily bases I created a macro in the templates to help us with our daily task but when we copy and paste the templates and try to run the macros it say there is an error , they still work perfectly in the templates but not in the ones we copied and paste I put the macro to work on all open workbooks but still having issues is there anyway to have the macro work on every openwork book without having to redo it 
    Wednesday, December 3, 2014 4:25 PM

All replies

  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel, I'll move your question to the MSDN forum for Excel

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    George Zhao
    TechNet Community Support

    It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.

    Thursday, December 4, 2014 7:31 AM
  • Hi mazy123,

    For this issue is difficult to find out the reason without the detail error message and code. Maybe, you use the relative/absolute path. Please provide the error message and code here.

    Best Regards


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 5, 2014 8:10 AM