If the USB is plugged in, then save onto it

[aca]

I want my macro to Save the workbook onto my USB E:\ drive, if I have it plugged in;
what is the syntax for the condition "If E:\ is available"... or "If USB exists"... ?

Thanks for any help.
AC

[CK76]

If you are only checking drive exists or not...

Something like below.

Please Login or Register  to view this content.

EDIT: DriveCheck() returns True if drive exists. So you can use that in your If statement. Also note that this only works for Windows based system.

[Marc L]

Other ways : just managing the Dir VBA function or searching for the volume name rather than the drive unit …

[aca]

Thank you, CK76; in fact, what I want is to go on and save my file onto the USB, if I have it plugged-in.
I'm not sure I'll know how to use all that code as just the condition for saving or not (or ending the macro).
ACA

[aca]

Thank you, Marc L. The fields you mention, Dir VBA and Volume name, are both new to me; I'll explore them.
ACA

[CK76]

Something like...

Please Login or Register  to view this content.

[aca]

Oh, oh... thank you very, very much, CK76! This is exactly what I need.
ACA

[CK76]

You are welcome and thanks for the rep