Thank you Tim for the information. We have some reports that needed to point to new library so, when I saw the the object name remain same and not changed to new library I was wondering what could be the reason for not changing. I agree with you that the object name change could break the VBA code. if the object name is only used for VBA scripting to uniquely identify the contents we need to document/highlight it so that people could know exact reason for not changing. I was searing all over the internet for any information on this but could not find any 🙂 but for some reports just use the SAS Addin to create pivot tables and don't use VBA code, the object name difference (with Name) could indicate wrong location/data. Please let me know if there are any alternatives. your information is really helpful! Thanks, Madhav
... View more
