usb

  1. L

    saveas workbook in vba - default location

    Hi I have saved a file in usb key. I opened the file from usb key. I ran the code below. I entered a new name, hello. The file was saved in C: drive under Documents, not in the usb key where the file originally was opened from! Why is that? Thank you very much Sub saveas_wb() Dim x As...
  2. A

    usb drive serial number

    Hi all, is there a way to get serial number of all usb flash driver with vba ?? I found a code in below website, but it gives Device id while I need to serial number of usb : https://myengineeringworld.net/2014/01/retrieve-usb-device-information-vba-wmi.html can someone help me?? Thanks in...
  3. L

    xls application for iOS that allows local storage or dropbox storage?

    Hi Excellers! Best wishes for 2019!! Is it possible to save Excel spreadsheets to local storage or to attached storage (lightning to usb adapter)? Any solution? It seems Excel for iOS forces one to a) login (to a MS account presumably...) b) store files to the MS cloud I've had numerous...
  4. T

    vba-Connect to internet using 3g usb modem (AT commands)

    Hi I need to connect to the internet through a 3g usb modem (Huawei E173) using AT commands. Is that possible?? I searched a lot but didn't find any instructions about how to do that. Thank u in advance.
  5. Mel Smith

    USB 3 v One Drive

    I have a fairly large Workbook with some 250+ worksheets. A lot of the data is entered on one sheet, which links through to several others and so on. The workbook is stored/saved to my OneDrive account but I’m finding that data entry is taking quite a long time. For example when I enter the data...
  6. E

    Finding USB device letter

    Hello ! As you know, the letter of an USB device can change. If you need to use a USB device in your VBA application, is it possible to use this: 'declaration Public DRIVELETTER Public Declare Function GetVolumeInformation Lib "Kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As...
  7. E

    Find the drive letter of an USB device

    Hello ! As you know, the letter of an USB device can change. If you need to use a USB device in your VBA application, use this: 'declaration Public DRIVELETTER Public Declare Function GetVolumeInformation Lib "Kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As String, ByVal...
  8. S

    Share a locked down pw protected Excel model

    I need to share a complex model with potential clients while at the same time keeping it secure. I've been using the excellent program XLS Padlock, but now many IT departments are blocking all .exe files (even camouflaged ones) via download or even usb drive. Short of mailing the client a...
  9. R

    Prevent data entry into Excel

    Hey all, so I have a program involving an RFID reader acting as a keyboard wedge. This means that whenever a tag falls within range of the antenna, the tag is put into the location where the cursor is on the computer. This creates a problem when running a program with cells and simultaneously...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top