View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron M.
 
Posts: n/a
Default Need code to save file to new folder, erase from old folder

I've tried working this out through VBA Help, but just can't get it
running. Can someone please help?
---------
Here's the task:

The user double clicks on a file in folderone to open it.

She makes some changes in a few cells, and saves it to foldertwo.

What we need is a button linked to some code that, after she makes her
changes, when she clicks on the button, it will save the file to
foldertwo, and delete it from folderone. The file name remains
unchanged.
-----------
This is for some funding review work we're doing. We fill in a template
spreadsheet on a project, then save it to a "ready for review" folder
(folderone).

Later, the final reviewer goes to that folder, opens the file, reviews
it, maybe changes a couple of things, then saves it to an "approved"
folder (foldertwo).

Then she goes back to the "ready to review" folder and deletes the
original, so they won't accumulate there.

She has hundreds of these to do, and it's extremely time-consuming and
tedious doing all this opening/saving/closing/deleting manually. So I'm
trying to make a button that will do it for her.

Thanks very much,
Ron M.