baitmaster
Well-known Member
- Joined
- Mar 12, 2009
- Messages
- 2,042
Hi, I'm using VBA to select a file and get the path to that file
The file I'm creating will be shared on a network, so I don't want it to capture drives mapped on individual users PCs, e.g. C:\... or M:\..., but the full network location \\network\blah\blah
How can I force the path identified to be a full network location instead of a shortcut location?
Code:
strSourceFilePath = Application.GetOpenFilename("Excel Files, *.xls; *.xlsm; *.xlsx")
The file I'm creating will be shared on a network, so I don't want it to capture drives mapped on individual users PCs, e.g. C:\... or M:\..., but the full network location \\network\blah\blah
How can I force the path identified to be a full network location instead of a shortcut location?