View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default 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