ChrisOswald
Active Member
- Joined
- Jan 19, 2010
- Messages
- 454
Running this code snippet with a workbook saved on a network drive:
Returns something like
x:\Dist Doc Stg\Saved reports\...\MyDoc.xls
or
E:\Dist Doc Stg\Saved reports\...\MyDoc.xls
depending on how the network drive is mapped.
How would I get it the domain type of drive name thing?
i.e.
\\corpshare.mycompany.com\GRPS\Institutional\Dist Doc Stg\Saved reports\...\MyDoc.xls
Thanks,
Chris
ps. what is the correct way to say "domain type of drive name thing" ? I'd probably have had better luck with an internet search if I knew.
Code:
StrThisSavePath = ActiveWorkbook.Fullname
debug.print StrThisSavePath
Returns something like
x:\Dist Doc Stg\Saved reports\...\MyDoc.xls
or
E:\Dist Doc Stg\Saved reports\...\MyDoc.xls
depending on how the network drive is mapped.
How would I get it the domain type of drive name thing?
i.e.
\\corpshare.mycompany.com\GRPS\Institutional\Dist Doc Stg\Saved reports\...\MyDoc.xls
Thanks,
Chris
ps. what is the correct way to say "domain type of drive name thing" ? I'd probably have had better luck with an internet search if I knew.