lkollmorgen
New Member
- Joined
- Feb 11, 2013
- Messages
- 8
This may be a difficult question to answer, because I can't supply the exact macros I'm using but I will try to give a good description.
Essentially the original workbook has data for multiple sales branches across different categories. The macro essentially makes a new workbook for each individual branch, so that each one can be sent to a branch without them seeing the others' data. To do this it just copies and pastes special values each tab after it selects the branch, then saves it as a new workbook and moves on to the next. That shouldn't matter too much for my question.
The original macro to do this was written in Excel 2007. When I started I was given a computer with Excel 2010. The macros would sometimes freeze up after a few branches and Excel would go into "Not Responding". It never broke in the same spot, and the branches it managed to finish were done correctly, so the macro didn't have any "bugs" causing the report to process incorrectly. The same thing happened on another report at my company when someone switched from 2007 to 2013, their report was unable to run. But I can run that report fine in 2010.
My question (finally) is, is there a decrease in available memory for macros happening as Excel comes out with new versions? To me it seems the opposite should happen. All these computers are running Windows 7 and have at least a I5 processor with at least 4GB of RAM, so the computer should not be the limiting factor. Thank you for any help you can give me!
Essentially the original workbook has data for multiple sales branches across different categories. The macro essentially makes a new workbook for each individual branch, so that each one can be sent to a branch without them seeing the others' data. To do this it just copies and pastes special values each tab after it selects the branch, then saves it as a new workbook and moves on to the next. That shouldn't matter too much for my question.
The original macro to do this was written in Excel 2007. When I started I was given a computer with Excel 2010. The macros would sometimes freeze up after a few branches and Excel would go into "Not Responding". It never broke in the same spot, and the branches it managed to finish were done correctly, so the macro didn't have any "bugs" causing the report to process incorrectly. The same thing happened on another report at my company when someone switched from 2007 to 2013, their report was unable to run. But I can run that report fine in 2010.
My question (finally) is, is there a decrease in available memory for macros happening as Excel comes out with new versions? To me it seems the opposite should happen. All these computers are running Windows 7 and have at least a I5 processor with at least 4GB of RAM, so the computer should not be the limiting factor. Thank you for any help you can give me!
