Apply Macro to New File

[Mick S]

This seemed easy when I started but am have trouble now.

I am trying to take one file and do the following steps:
1. Create new folder based on a few cells in the file
2. "save as" the file to the newly created folder
3. Copy paste values the newly created file on all tabs
4. Take newly created value file and break it up again into smaller files with just a few particular tabs (savng them in same folder)
5. Email smaller files to individuals based on an independent excel file.

Currently stuck on #3. It is only paste valueing one sheet instead of all of them. I've used this same block of code in another file but never in something I've just "saved as". Am I not coding it to the newly created file? is that the issue? and if so how do I do that?

Please Login or Register  to view this content.

[Mick S]

Figured it out on my own but for anyone else wondering:

Instead of "thisworkbook" it needed to be "activeworkbook" in step 2 and 3.