View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pano[_3_] pano[_3_] is offline
external usenet poster
 
Posts: 30
Default Save workbook To any USB Drive no matter what drive letter

Hi all, I have tried the search and cannot get any of the other VBA
macros to work re this subject!!

I want to be able to press a button on a sheet on my workbook and have
a macro save the workbook to a USB drive which could come up as either
drive D - E or F. No prompts just save a copy.

Any help at all would be appreciated immensely as I dont have a clue
re VBA. I'm sure that someone must have code that works.

This is the last thing I need to complete the project.

Thanks in advance
Stephen