Macro won't run - WrkBk name keeps changing

The following code unhides and copies the "Data" tab from a doc called Aliant Call Profile Report (End of Day) and then pastes it into a tab called NBReport Data on a document that doesn't have a set name so I've used ActiveSheet.Paste. The problem I have is now Aliant Call Profile Report (End of Day) is no longer the name. Excel seems to want to continue adding (1),(2),(3), etc... to the end of my filename. I know about the excel /unregserver but that did not solve my problem. Is there a way to modify my code to account for the fact that my filename won't stay the same?

Please Login or Register  to view this content.