I expect this is very simple once you know how and I think I am 90% of the way there but can't quite make the magic happen!
I have a file with around 50 tabs that I want to make into individual files. I want to save them all in the same drive (Say C\Documents\Properties) and I want to name each file after its tab name.
Any assistance with a macro to do this will be greatly appreciated.
Many thanks
I have a file with around 50 tabs that I want to make into individual files. I want to save them all in the same drive (Say C\Documents\Properties) and I want to name each file after its tab name.
Any assistance with a macro to do this will be greatly appreciated.
Many thanks