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.