Dear Friends
I need your help regarding how to create a directory using Network Login Name.
I know we can make directory MyDirectory at C:\ using one-line code
[VBA]MkDir "C:\MyDirectory\"[/VBA]
But suppose if I want to share my macro-code (in which I need to create directory while running it first time) amongst different users on a network, for example, users A,B and C log in into the network using their login names UsernameA, UsernameB and UsernameC respectively; and they have their network drive with their login name folder H:\Netowrk Username\ , then how can I make MyDirectory in this folder.
I mean on the network drive,
H:\Network Username\MyDirectory
where Network Username would be UsernameA for A, UsernameB for B and UsernameC for C.
I hope you would understand what I mean to write here.
Thank you once again.
Best Regards
Vishalkumar