I have a file that opens with 1 sheet visible. Some data is imported to the sheet and once the data is verified, there is a button to save the file with a very specific name and in a location by the user. Once the file saves there are other sheets that will become visible with new macros. When working in the original file everything works smoothly, however, once the file is in the new file name, all the macros open the original file. I have been able to put a line of code to close the file but I would prefer to understand why this is happening and fix the code. It seems that there are a lot of things happening in the background making the code less efficient and slow (the page blinks a lot). I have attached the Save As macro as well as another macro that is executed in the new file. I am no VBA expert so the help is appreciated.
Please Login or Register to view this content.
Bookmarks