|
Re: Recursive Function + File searching to return path
And just to encourage you further to follow Bob's advice about rolling
your sleeves up (and catching some fish)... don't be put off by your
network / addin installation concerns. There are many ways to deploy
this, a few examples:
(a) Run as an AddIn on the network - just give your users a shortcut to
the AddIn and all they need to is doubleclick, enable macros (if set to
security is set to Medium) and away they go.
(b) Install it as an AddIn, still on the network - not locally
(otherwise upgrading is a pig). This way it will be available as soon as
Excel starts, there are no security flags to worry about. (You can even
use VBA to install the AddIn for you - so you can minimise time spent
with the end users.)
(c) Place your code in a workbook, on the network. Have the users access
that.
(d) Place your code in a workbook in Outlook Public Folders....
etc. etc.
YOu get the picture. Deployment shouldn't be a problem.
HTH
Gareth
Bob Phillips wrote:
> I haven't read all of your post (life is too short :-)).
>
> Why don't you do some of the work, try the code, and then come back and tell
> us what it does that you don't want/ what it doesn't do that you do want.
>
|