Hello all,
I was hoping to find some help on a Looping issue which I can't find my way out of. I have an excel workbook which calculates a costing, there is a command button on the sheet which when clicked opens up a word template, which has strategically placed bookmarks. The code then continues to execute and populates the bookmarks with the contents of cells specified in the code. Due to tight formatting restrictions I would like to use Text Boxes with bookmarks placed in them. However my script keeps tripping over at the point where I'm trying to call my first Textbox. An error message is displayed which states "Command can not run as no document is open" however the document has opened and the first bookmark has been populated.

Here is a condensed version of what I have;

Please Login or Register  to view this content.
Any help or advice on this would be wonderful.
Thanks
B