I'm currently stuck on this VBA Code. What I'm trying to do is copy and rename files in a directory using an Excel macro. For example, C2 is the source folder and D2 is the destination folder. A2 is the old file name and b2 is the new-to-be file name. It works only for one cell. I'm trying to do this for more than 3k files. I've used ",". WHen I use ":" i get an error. how do i tell the macro to go through all sales with in a column.
Please Login or Register to view this content.