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...
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...
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...
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.