Macros

liamboyle06 · 03-06-2005, 10:40

Hi everybody
I am being introduced to the world of macros and sript writing and am completley swamped by it.

I am trying to write a macro, so that if a file has a particular name, it will move it to a designated folder. i have a list of csv files all different names. I need to be able to move the files into specified folders. can this be done in a macro script.
Any other help would be advantageous.

iron25 · 03-06-2005, 22:50

Okay I'm assuming you are talking about VBA & VB Script. If so, start here http://msdn.microsoft.com/library/de...FileSystem.asp.

The filesystemobject will allow you to do everything that you want to do. You will also have to use the Files Collection & Folders Collection, the links are on the same page.