I have put a button on a questionaire that is sent out to people all over Europe, (On my PC:Excel 2002, Windows 2000).
Behind this button there is a macro asigned, when clicked it will attach the questionaire sheet to an email, add my email address in the To box, and put in a subject, ready for any eurpoean to send the complete qustionaire back to me.
But although it works fine in the UK, it presents an error in Germany and probably will do in other countries also.
The error is: Run-time error '1004': Show method dialog class failed.
How do I overcome this so that it works no matter where from, using Lotus Notes.
The code used is:
Sub Macro4()
'
'To attach file to email, insert name and subject then close excel
Sheets("Survey").Copy
Application.Dialogs(xlDialogSendMail).Show "my.email@address.com", "Attached - Completed Survey", True
'xlDialogSendMail recipients, subject, return_receipt
ThisWorkbook.Save
ActiveWorkbook.Close SaveChanges:=False
Application.Quit
End Sub
Has anyone please got any idea.
Narpal
Behind this button there is a macro asigned, when clicked it will attach the questionaire sheet to an email, add my email address in the To box, and put in a subject, ready for any eurpoean to send the complete qustionaire back to me.
But although it works fine in the UK, it presents an error in Germany and probably will do in other countries also.
The error is: Run-time error '1004': Show method dialog class failed.
How do I overcome this so that it works no matter where from, using Lotus Notes.
The code used is:
Sub Macro4()
'
'To attach file to email, insert name and subject then close excel
Sheets("Survey").Copy
Application.Dialogs(xlDialogSendMail).Show "my.email@address.com", "Attached - Completed Survey", True
'xlDialogSendMail recipients, subject, return_receipt
ThisWorkbook.Save
ActiveWorkbook.Close SaveChanges:=False
Application.Quit
End Sub
Has anyone please got any idea.
Narpal