Quote:
Originally Posted by chirayu
Thanks macropod, works great... confusing because I hardly ever use DIM so will need to decode it.
|
You should always use Option Explicit and Dim your variables; otherwise all sorts of strange, hard to resolve, errors can occur.
Quote:
I had another linked question instead of giving it a predefined folder path to run - is there a way to make it run from wherever it is opened.
As in I open my first file and run the macro, it will auto pick the path from my first file and do it work and move onto next file?
Is there also a way to tell it to give me a select folder option?
Like when I run the macro it will ask me if I want to start from current file and folder or choose a different folder?
|
Please make up your mind what you want to do - do you want to run it from the active document's folder, the folder of the document the code is in, or do you want to choose the folder. Any of these is possible, but you can't realistically do all at the same time.