Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pinda
Hello,
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 prompts the user (with a dialogue box), to save the spreadsheet, move or copy the folder to the outbox, and then close the file down. I understand that this is possible using the saveas function and then the kill function (deleting the file in the inbox), but my VBA knowledge is only basic and I am finding it difficult to execute the code. Could someone please help me with code, it will be very much appreciated. Thanks in advance, Pinda. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|