Hi everyone,

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

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

I wish to attached some code to a button that saves the spreadsheet and then
prompts the user (with a dialogue box), asking if they want to move or copy
the folder to the outbox, and then close the file down.

I understand that the move may not be possible, as the file is stil open,
but the copy (save as) will be possible.

Any help would be much appreciated.

Also, is it possible to save MS word files through excel VBA code??

Thanks in Advance.

Pinda.