ATTN: Tom Ogilvy or anyone else: send DOS command?

[quartz]

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.

 

[Patrick Molloy]

open "c:\temp.bat" for output as #1
write #1."copy a.htm + b.htm + c.htm d.htm"
close
shell "C:\Temp.bat"

 

[quartz]

Thanks Patrick.

I copied the files to C:\ and renamed them with short names (e.g.
XLHTM1.htm, XLHTM2.htm, etc.). Running the code you suggested executes
without error, but fails to do anything.

i.e. No combined file is generated...what am I doing wrong?

 

[Jim Thomlinson]

You can execute the function without createing the batch file... Check out
this article...

http://support.microsoft.com/default.aspx?scid=kb;en-us;213800

so it will look something like...

Shell "command.com /c copy a.htm + b.htm + c.htm d.htm"

HTH

 

[Dave Peterson]

See one more response at your other thread.

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.

 

[quartz]

Thanks to all who responded, you guys really nailed it forme. It works great
and is EXACTLY what I needed. Thanks a lot!