How to access word files from excel

[Alex St-Pierre]

How can I open word file from excel? I have a lot of word
files to open and paste in different directory. (I don't
have modification to do inside the files) I think that it
is impossible to open word file from excel. But I would
like to know if there is a possibily to access the files
and duplicate it in a chosen directory.

Alex

 

[Rick Stebbins]

If I understand you correctly, you could use the
VBA.FileCopy command. Although you'd have to prevent
errors by verifying that the target filename does not
already exist, the target folder does exist, and the
source file is not locked.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnofftalk/html/office09072000.asp

 

[Cindy Meister -WordMVP-]

Hi Alex,

It's not really clear what you need to do. You shouldn't
have to open files to copy them to another directory. Look
up FileCopy in the Excel VBA Help (it's actually a VB
function across all of Office).

How can I open word file from excel? I have a lot of word
files to open and paste in different directory. (I don't
have modification to do inside the files) I think that it
is impossible to open word file from excel. But I would
like to know if there is a possibily to access the files
and duplicate it in a chosen directory.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail