I would have thought that would be pretty easy, but I've done a lot of VBA programming and haven't had the need to do this yet. I just looked at a book I have that is very good and I'm not seeing anything.
However, it is very easy to copy files in Excel. It may be pretty easy to do what your exe file is doing in VBA. This is from the online help:
Dim SourceFile, DestinationFile
SourceFile = "SRCFILE" ' Define source file name.
DestinationFile = "DESTFILE" ' Define target file name.
FileCopy SourceFile, DestinationFile ' Copy source to target.
For the Newbie, the book I have that is very good is:
http://www.amazon.com/exec/obidos/tg/detail/-/0764532634/qid=1055343450/sr=1-2/ref=sr_1_2/104-4479641-1799929?v=glance&s=booksHe also has a 2002 version out now.
The arthur also has his own web page that's pretty good.
http://j-walk.com/ss/>Hi all...
>
>I am trying some Excel programming, so forgive the 'newbie-ness'... :-)
>
>I have a small program (copyfiles.exe) which moves some files around (funny name, eh?). Anyway, I want to create a macros to run this .exe from within Excel. I don't know alot about Macros and the like, so I would appreciate an example of what I should have.
>
>TIA
>
>
>Ric
___________________________
Kenneth Wonderley
http://www.wonderley.com...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23