| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
write usb flash drive information in to excel cell
Look into working with WMI using the "\root\CIMV2" namespace. The info
you want is available but requires running queries in several WMI classes so that you're sure you're polling the correct USB device... Win32_LogicalDisk Query this class filtering only USB drives via DriveType = "1" (RemoveableDisk). Make sure you check its ID matches its drive letter (Path). Note that the device.ID is its system descriptor (drive assigned when it got plugged in) Win32_DiskDrive Query this class for its ".PNPDeviceID" and its ".Size". The PnpDeviceID for my Kingston DataTraveler stick returns as... "USBSTOR\DISK&VEN_KINGSTON&PROD_DATATRAVELER_2.0&R EV_PMAP\5B8805000088&0" The Size for this drive returns as "8003197440" ...which gives you lots of info to work with from just 2 values. HTH -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when I put my flash drive in, the computer does not give me drive | New Users to Excel | |||
| How do I copy excel file to a flash drive? | Excel Discussion (Misc queries) | |||
| Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
| How do I use flash drive in Excel.(selected drive is not in use) | Excel Discussion (Misc queries) | |||
| Pasting a range of information from a foler on F Drive to another folder on same drive | Excel Programming | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
