"Don't hardcode your filepaths" I was told. "But it's only ever going to be on my machine!" I said. Well, it will *still* be only my machine - when IT gives it back, that it. Yesterday, WHAM! and CRASH! Data's good, but tomorrow I get it back with XP and a whole new set-up. *Now* where are my folders and files?!? asks my macros

I can either visit each macro as it errors and hardcode new paths, setting myself up once again for running face-first into brick walls I was told were there! Or I can put a command to the Open dialog and Browse each time - but I have better things to do. Or I can learn how to tell my code to search and find a certain folder or file. I know this means haing to name folders and files in an easily-recognized manner (vice NewFolder2, NewFolder3, Stuff, OldStuff, and other originalities)

*sigh* Okay - where do I start? A drop-kick in the right direction is appreciated

Ed