xlDialogSendMail Error

  • Thread starter Thread starter Gavin Smith
  • Start date Start date
G

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
 
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
 
Hi Gavin

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

I hope anybody else can help you
 
Back
Top