Macro to rename and move files

Hi all wise Excel gurus,

I am in desperate need of a macro that can do the following :

1. Find a file in a certain folder by a few letters, ie "002" in a file called "Fordprocs002.txt"

2. Then move that file from C:\test to c:\tested and rename it to "O2009.txt"


Additionally it would be great if its possible to get that file into a new message in Lotus as attachment and with 4 addresses in BCC and Subject "Results"

I have searched so much to find this out, and cant seem to get it right, as Im not too skilled with scripts. So any copy paste material would be a lifesaver here..

Caroline

Here is a link to a post with a routine for the email http://www.excelforum.com/showthread.php?t=601096

Great, tnx alot for your help guys. Will try it tonight, and post results

Have a nice saturday all.

Hi, I got this error message : Object doesn't support this action (Error 445)
when I ran macro for renaming files. What am I doing wrong? Pasted it in as above.

Caroline

I use Excel 2003; not sure if earlier versions of Excel support the scripting library. In any event, make sure that you have a reference checked to the scripting library.

Please post your code.

Think problem is that Im messing around in Excel 2007 now, will try at work tomorrow in excel 2003.