kirkm wrote:[quote="Is there a way to use the macro spreadsheet over a network.
Bert's suggestion about mapping drives is spot-on but editing the config sheet directly was pretty clever.
Cheers - Kirk[/quote]
Interesting - I was having the same problem. I have an external Hard Drive mapped as F:. I created the file structure manually, using the spreadsheet and the utility but everytime I put in the path (F:\Singles2\Britburn) it wouldn't recognise it even after the S/Sheet went active. If I tried to import the files it created the directory structure directly under My Documents.
I sort of gave up putting it down to a quirk in Excel - years of being a server engineer and networking/sharing Excel (along with Printing) always gave us big headaches.
However I used BoroButch's trick and now it all works (rather brilliantly may I add!).
Now I have to move all the files as my current structure is slightly different, but it's a good chance to audit and clean up.
But the labels do look really good and a great enhancement.