Tom, what is the best way to check for an existing file/directory? The
DIR function?

Charles
Tom Ogilvy wrote:
There are also built in function in VBA

mkdir
chdir
kill
filecopy
name (moves a file)
many others.

--
Regards,
Tom Ogilvy


"kk" wrote:

Hey Charles,

Looks good. Thanks.

Vivek

"Die_Another_Day" wrote in message
ups.com...
Vivek, check out this page from Tek Tips, it has some really good info.
http://www.tek-tips.com/faqs.cfm?fid=4116

Charles

kk wrote:
hi

Are file operations possible as part of Excel macros?

Looking for something similar to what's available in a batch file.

e.g.

create folder
move or copy file

Vivek