1. In Excel Goto Tools>Customize...
2. Click on the 'Toolbars' Tab
3. Click New.., Enter a Name and Click OK
4. Your new toolbar should appear as a grey box.
5. Next Click on the Commands Tab
6. Scroll Down the listbox on the Left, until you get to macros, click it once
7. two items should...
When using the FileSystemObject from the MS Scripting Runtime; i'm trying to extrapolate the Sharename of a drive.
When looking at other code, it appears that the drivetype must be 3 (Network shared), I'm using Windows XP Sp1 and my drives are shared, but the FSO reports them as being DriveType...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.