excel file saving conditions

Hi,


How to restrict to save excel file in External device (ex: usb, pen drive) and C Drive in using vba code. this macro should work on any system.

thank you in advance


regards
shiva

Hi,

thank you for your reply.

My code asks user to choose folder from system. if anyone choose any folder from usb or pen drive then macro has to give warn to user as " Pls don't select folder from USB or External Device or C drive. Choose Any folder from D/E/F Drive"

regards
shiva