Thanks, that seems to work much better.
So I need to close the workbook after I write to it in order to save the changes? The write dosen't work even with the or fixed unless I close the workbook. Is there a way to continue editing the workbook (allow for multiple URLs to be used) after the write?
You can read the the documentation, but I'm guessing you will need to close the workbook before the changes take effect. So your choices are probably limited to: