To do this kind of thing you need SHELL commands. Suggest you put your DOS
commands into a .bat file and call the file from VBA:

t = Shell("command.com /c yourfile.bat")

--
Gary''s Student


"JasonSelf" wrote:


How would I copy a directory(this does have things in it if that
matters), for the sake of this example "C:\orig" to a new location
"C:\dest" The code I have written keeps giving me an error.


dim origdir as string
dim destdir as string
origdir = "C:\orig"
destdir = "C:\dest"
filecopy origdir, destdir

I have also tired ending the dir strings with backslashes and that
doesn't seem to work either.

Thanks in advance for any help,
Jason Self


--
JasonSelf
------------------------------------------------------------------------
JasonSelf's Profile: http://www.excelforum.com/member.php...fo&userid=5330
View this thread: http://www.excelforum.com/showthread...hreadid=469555