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.

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" wrote in message
...
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.

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?

"Patrick Molloy" wrote:

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" wrote in message
...
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.

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

http://support.microsoft.com/default...b;en-us;213800

so it will look something like...

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

HTH

"quartz" wrote:

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?

"Patrick Molloy" wrote:

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" wrote in message
...
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.

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

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