Excel - Controlling word - Object Error

Hey guys,

Having a slight problem with some code that that copies some cells on to a template sheet, and then that template sheet into word and save a doc.

this is the code - I highlighted the dodgy bit in red:

Please Login or Register  to view this content.

I'm sure I have set the object up but I get the error:

Object variable not set (Error 91)

Can anyone see why it would be doing that?

Thanks! I'm so close

(I'll attach my sheet to make it easier if needed)

lol now I just feel like a dumbass :D

Thanks a lot that works perfectly.

Just one more thing: is there a way to make my code save the docs in a specific folder and have a name that refers to a cell?

I would assume that I have to edit this line of code:

Please Login or Register  to view this content.

I know you could just put the cell but then it would use that cell for all the files, and this macro makes multiple word docs so it baffles me a tad.

lol nope got a massive error

What would happen if I leave off

Please Login or Register  to view this content.

Would it ask me to save it somewhere? Spose if u had 100 though you would have to click 100 times.

I'll have a play thanks for the help anyway!

Woh woah hang on

Please Login or Register  to view this content.

that works

Names them correctly