Prev: Insert a new Worksheet AFTER the existing (Active) sheet
Next: Comments
From: Greg on 12 Jan 2010 11:41
hi,

is there a way to show a network drive via formula when a drive is being
mapped?
Different users mapping of the same drive to a various letters is causing
issues.

I thought of writing an UDF combining a string with a network drive name
with a combination of cell("filename") & hyperlink function, but there has to
be an easier way.

Thank you,

--
______
Regards,
Greg
From: Bob Phillips on 12 Jan 2010 12:38
Take a look at
http://vbnet.mvps.org/index.html?code/network/uncfrommappeddrive.htm

HTH

Bob

"Greg" <Greg(a)discussions.microsoft.com> wrote in message
news:3FE88F5A-B702-4904-A913-8C592E4B6557(a)microsoft.com...
> hi,
>
> is there a way to show a network drive via formula when a drive is being
> mapped?
> Different users mapping of the same drive to a various letters is causing
> issues.
>
> I thought of writing an UDF combining a string with a network drive name
> with a combination of cell("filename") & hyperlink function, but there has
> to
> be an easier way.
>
> Thank you,
>
> --
> ______
> Regards,
> Greg


From: Greg on 12 Jan 2010 14:16
thanks, Bob. I'm on Vista though and it's not listed there

"Bob Phillips" wrote:

> Take a look at
> http://vbnet.mvps.org/index.html?code/network/uncfrommappeddrive.htm
>
> HTH
>
> Bob
>
> "Greg" <Greg(a)discussions.microsoft.com> wrote in message
> news:3FE88F5A-B702-4904-A913-8C592E4B6557(a)microsoft.com...
> > hi,
> >
> > is there a way to show a network drive via formula when a drive is being
> > mapped?
> > Different users mapping of the same drive to a various letters is causing
> > issues.
> >
> > I thought of writing an UDF combining a string with a network drive name
> > with a combination of cell("filename") & hyperlink function, but there has
> > to
> > be an easier way.
> >
> > Thank you,
> >
> > --
> > ______
> > Regards,
> > Greg
>
>
> .
>
 | 
Pages: 1
Prev: Insert a new Worksheet AFTER the existing (Active) sheet
Next: Comments