Hello Nick,

It's working fine now, after implementing your suggestions.
Thank you!

Ward


-----Original Message-----
ward,
After using your code, I see that it works, but you end
up with a hidden
workbook. Open the file, then Window Unhide and you
will see it.

Exactly why it ends up hidden, I'm not sure, but there
are a few
inprovements that could be made to your code.

Create a new instance of Excel for your macro to use

Set xlApp= New Excel.Application
Set wb=xlApp.Workbooks.Open("C:\test\test.xls")
.....Code
wb.Save
wb.Close < which you are not currently doing

xlApp.quit < which you are not currently doing

Whether you the xlApp visible or not is up you.

NickHK