Hi everyone,

I know how to save a spreadsheet using VBA, but I want to move/copy th
file
after it has been saved, is this possible?

I am creating a system where spreadsheets get dropped into an Inbo
folder
(e.g. c:\Inbox) folder and then moved or copied to an Outbox folde
(e.g.
c:\Outbox), once they have been edited and saved.

I wish to attached some code to a button that prompts the user (with
dialogue box), saves the spreadsheet, moves or copies the folder to th
outbox, and then close the file down.

I understand this can be done using the saveas function and the kil
function (to delete the file in the inbox), but my VBA knowledge i
only basic and I am having trouble executing the code.

Could someone please help me with the code? Any help would be muc
appreciated.

Thanks in advance.


Pinda

--
Pind
-----------------------------------------------------------------------
Pinda's Profile: http://www.excelforum.com/member.php...nfo&userid=117
View this thread: http://www.excelforum.com/showthread.php?threadid=27608