ATTN: Tom Ogilvy or anyone else: send DOS command?
Thanks to all who responded, you guys really nailed it forme. It works great
and is EXACTLY what I needed. Thanks a lot!
"Dave Peterson" wrote:
See one more response at your other thread.
quartz wrote:
I am using Office 2003 on Windows XP.
I want to send the following DOS command through VBA in Excel:
copy a.htm + b.htm + c.htm d.htm
This command should append a, b, c to a new file d.
Can Tom (or someone who knows) please post example code showing the correct
syntax to run this command? I'm assuming it has to be Shell-ed out.
These files reside on a network share like:
\\fs5\finance\corporate accounting\a.htm
Thanks in advance for your assistance.
--
Dave Peterson
|