Open Word SaveAs dialog from Excel VBA

Using Office 2003 and Windows 7 Professional:

I'm using Excel VBA to populate a Word document template with data from a spreadsheet. Once the process is complete I want the user to be able to save the Word document using a Word SaveAs dialog but can't find the right syntax to open this.

My code has

Set wordapp = CreateObject("word.Application")

then when I want to open the SaveAs dialog

wordapp.Dialogs(wdDialogFileSaveAs).Show

but this brings up an error Run-time error 5941 - The requested member of the collection does not exist.

I have added Microsoft Word 11.0 Object Library in the references and don't know what else to try.

Grateful for assistance.

No luck with that suggestion - it just opened a Microsoft Office Word Help window which was completely blank apart from the title.

Here is the code that finally worked:

Please Login or Register  to view this content.

The only problem is that the Excel spreadsheet is on top, and the dialog appears with the Word window, and is therefore hidden until I select the Word window. Is there a command which will bring the Word active document to the front before the SaveAs dialog is called?

Grateful for assistance.