Stacking Files in a Folder, 2 tabs

Hello, I have written below code to automate the stacking of files saved in a specific folder. Now, I am trying to tweak the code to add the last report, ABC-4 to a different tab. Currently, its being stacked underneath the other 3. I also want to rename both tabs to "new name 1" and "new name 2".

Any help would be greatly appreciated!

Thanks,

Please Login or Register  to view this content.

you said:

Originally Posted by sm26mz

Now, I am trying to tweak the code to add the last report, ABC-4 to a different tab. Currently, its being stacked underneath the other 3.

it doesn't really look like it is. this is the only relevant code:

Please Login or Register  to view this content.

and then you are closing it. the only new file you are creating is being done with this:

Please Login or Register  to view this content.

soooooo....you are saying that you want to save a BOOK to a different TAB. that really is inconsistent. is that what you meant to say?