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
Bookmarks