xlDialogSendMail Error

[Gavin Smith]

Rather than post all code - this error can be replicated
as follows.

(1) With a new workbook create a Form with one command
button on it.

(2) In the click event of the command button insert the
code:

Private Sub CommandButton1_Click()

Me.PrintForm
Application.Dialogs(xlDialogSendMail).Show
Unload Me

End Sub

(3) Create a module with code showing the form

(4) Add a form button to your worksheet and associate it
with the macro calling the form

(5) Let it run and - hey presto! You should get
the "Path/File Access Error" code.

Got any ideas?

Gavin






Show us your code Gavin

 

[Ron de Bruin]

Hi Gavin

I tested it in Win XP Office 2002 and WinXP Office 97.
No errors for me?

Do you have more information to reproduce

 

[Guest]

Only that error occurs in Excel 2000 but not on Excel 97

-----Original Message-----
Hi Gavin

I tested it in Win XP Office 2002 and WinXP Office 97.
No errors for me?

Do you have more information to reproduce


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"Gavin Smith" <[email protected]> wrote

in message news:[email protected]...

 

[Ron de Bruin]

Hi Gavin

Same for me in 2000, but I have no solution for you.

I hope anybody else can help you