VBA to create folder and then save multiple files In

[ZeDoctor]

Hi Guys,

Got a bit of a complicated one (considering I am pants with VBA). Below is my code I have so far.
I'm attempting to click a macro button that would then run and

1. Create a folder based on a cell (S6)
2. Filter the pivot table based on the input (This bit works fine)
3. Save a new file named based on a cell (S5) within the folder created
4. Filter the pivot table to new criteria (Again, works fine)
5. Save new file based on cell (s5) within folder created
6. Repeat with all pivot criteria....

Sorry my code is a massive mess, I picked up the folder creation and saving VBA from the internet and have been trying to play around with it but to no avail

Any help massively appreciated

Please Login or Register  to view this content.

[JapanDave]

Post a workbook, and what exactly is the problem? Can't drag myself through the code at 3am in the morning.

[ZeDoctor]

JapanDave, you're a hero being on here at that time. Sadly I'm not at my computer so can't upload but will when I get the chance, but I'm guessing you'll be in dreamland by then.

The problem is when I run the script it runs through like it worked but nothing has been saved at the end of it .

Thanks for the reply anyway Mr Dave