software

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 quot;ready for reviewquot; 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 quot;approvedquot;
folder (foldertwo).

Then she goes back to the quot;ready to reviewquot; 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.Ron,

As the save macro:

Sub SaveInApprovedFolder()
Dim DeleteFile As String

Application.DisplayAlerts = False
DeleteFile = ActiveWorkbook.FullName
ActiveWorkbook.SaveAs quot;Drive:\Approved file path\quot; amp; ActiveWorkbook.Name
Kill DeleteFile
Application.DisplayAlerts = True
End Sub

HTH,
Bernie
MS Excel MVPquot;Ron M.quot; gt; wrote in message oups.com...
gt; I've tried working this out through VBA Help, but just can't get it
gt; running. Can someone please help?
gt; ---------
gt; Here's the task:
gt;
gt; The user double clicks on a file in folderone to open it.
gt;
gt; She makes some changes in a few cells, and saves it to foldertwo.
gt;
gt; What we need is a button linked to some code that, after she makes her
gt; changes, when she clicks on the button, it will save the file to
gt; foldertwo, and delete it from folderone. The file name remains
gt; unchanged.
gt; -----------
gt; This is for some funding review work we're doing. We fill in a template
gt; spreadsheet on a project, then save it to a quot;ready for reviewquot; folder
gt; (folderone).
gt;
gt; Later, the final reviewer goes to that folder, opens the file, reviews
gt; it, maybe changes a couple of things, then saves it to an quot;approvedquot;
gt; folder (foldertwo).
gt;
gt; Then she goes back to the quot;ready to reviewquot; folder and deletes the
gt; original, so they won't accumulate there.
gt;
gt; She has hundreds of these to do, and it's extremely time-consuming and
gt; tedious doing all this opening/saving/closing/deleting manually. So I'm
gt; trying to make a button that will do it for her.
gt;
gt; Thanks very much,
gt; Ron M.
gt;