• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Save errors

F

Flexorion

New Member
I'm having a problem with a very complicated macro I created that works fine while I'm using it, but then when I save and close and reopen it, an error is inserted into the code. I found the place where the error is, and I can manually go in and delete it, but I would like to know why this keeps happening. Is there some kind of setting I can change so that the VBA code won't be altered when I save and close?
 
I think a possible problem might be that the original file I'm working from was saved in an older Excel format. But the macros I saved specifically to that notebook, and when I try to save it to Excel 2010 format, the macros are stuck in the old file and don't totally transfer over. How do I move my saved VBA from one workbook to another or to a general workbook?
 
Never mind, that was the problem. There were self referencing macros within the macros, so I had to go through the code and everywhere in the code where the old file was mentioned I had to put in the updated file in 2010 format, so there are nomore problems now.
 
You must log in or register to reply here.
Back
Top