I have a list of beginnings of filesnames in excel ,
I want to make a macro that will move them from one defined directory to the other
The file name are named like this AAAAXXX
AAAA- are unique numbers that i will put in excel
XXX- are also unique number but i want macro to skip them while moving/copying files
I tried using * after the file name but it read it as part of file name and not as a wildcard
I found out that Fso.Movefile doesnt work when i put variable in it . how can i solve it ?
Or i do need to use other command
Is it possible to do it without using library?