ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro error message (https://www.excelbanter.com/excel-programming/367840-macro-error-message.html)

Mary Thomas

Macro error message
 
Hi, another excel dummy question I'm sure, but here goes. I recorded a macro
in excel to got to FileSend as Attachment.
The actual VB text reads:
Sub SubmittoPPI()
'
' SubmittoPPI Macro
' Macro recorded 07/20/2006 by MSMD11
'

'
Application.Dialogs(xlDialogSendMail).Show
End Sub

It works fine on my pc but when I test it on someone else's pc we get the
following error message:
Method of Dialog Class Failed.
Can anyone help me fix this error? we are using Lotus Noted not Outlook. I
don't know if that is relevant or not.
Thanks,
Mary
--
MT


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com