ok, since a userform macro that i've made recently cuts down a lot o
manual processes at the office and moves everything to a totall
electronic format, i've been told that I need to make sure that there'
always a back up in case something happens, so I've decided to add t
the userform, telling it to save to a removable storage device, th
thing is, since it's removable and often swapped between 2 pc's, wha
can I add to the macro to tell it, if this drive is present, save th
file there.

It's been the case with vba when i've tried to open workbooks i
folders that don't exist to just ignore it, and not give me an error
but i don't know if it'll do the same thing when trying to save

--
Message posted from http://www.ExcelForum.com