Save as copy and then use that copy

[Will S]

Hello,

I think I'm asking for more than is possible here but it's worth asking nonetheless. I'm trying to make it so that on click of a button for my excel sheet to:

1. Save.
2. Save a copy in my documents
3. Use that new copy to run a print macro.

Currently I can get it to save and then create the new copy, is there a way to open that sheet and then run a macro on that sheet?

Any help is greatly appreciated,
Will S

 

[BrianMH]

If you use saveas (not savecopyas) on an object that object refers to the newly saved object automatically so you would just run your macro as normal.

 

[Will S]

...Well that went better than expected.

Thank you, that has been a huge help, I really should of tried something like that sooner, but thank you for pointing me in the correct location!

 

[BrianMH]

Glad to help