Search results for query: *

This code is intended to save a worksheet to the hard drive And a flash drive no matter what the drive letters are. It mainly goes by drive type and volume label but has stopped saving to the USB drive. Skip V. mentioned to me that I should add Watch Variables to see what the values are for...

The runtime error is 464, object required. I did do the "Notify Before State Loss" in the General Tab. It made no difference.

Runtime error 464; Object Required. Oops.. *** This is the Original Flashback Sub written to save a worksheet to the hard drive and whatever USB drive is connected. I am now getting a run-time error that says "Object Required" on the line marked with asterisks. Thank you again to strongM...

yes, that would make the IF false and the eject would never work.

Good, glad someone else has a use for it. Use Strongm's version of the code, but take the IF-Endif out around "usbdrive.invokeverb "EJECT". it will remove the flash drive faster than a child running from the dinner table after seeing veggies...

Strongm: take a couple statements out, substitute others and your sample works.. Thank You..

Yes, but I missed some things in my haste. What I did was ro run another macro first from a command button. This macro runs fine but does not eject the flash drive. After I have all the backups saved, I Call EjectByName(16) where "16" is the volume label of usb (F:) drive. I put a msgbox in...

I did all that, called it from my original coding and it looks like nothing happened. System tray still says "Eject Ultra Backup". Is there a way to tell in code if the drive is actually unmounted? Where do I look for coding references? VBA or MS Scripting? Never worked on anything in this...

' Assumes you have set references to Microsoft Scripting Runtime and Microsoft Shell Controls and Automation Where do I find this information other than what I have already set? I am using the visual basic editor is all I know. I have not done all that much with this.

Hopefully I can concatenate a character string to give the path that the Shell command requires. I read the shell command last night and there are some switches in there that may help. By "friendly name" I assume they mean Volume Label??

I am looking for a way to automatically Eject a flash/usb drive after backup. The backup goes to drive C: in a hardcoded path, then uses a for-each next to find the usb drive and copy to a hardcoded folder, then resaves to C: for subsequent saves. Andy (one of the programmers on here) sent me...