LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default xlDialogSendMail Error

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Gavin Smith" wrote
in message ...
I am experiencing a similar problem with the use of the
xlDialogSendMail object. I have a form that generates a
spreadsheet then presents the user with the dialog box,
the user enters the custom details and send the email.



This all works fine, I then unload the form, and this is
where it gets confusing. If we are in break mode and
stepping through when we reach the last 'End Sub' or
an 'End', i.e. the code is to stop running, we
get 'File/Path Not Found' error and can no loner run any
code that references any form in this workbook, or view
any form or the code behind any form in this book and get
the error message again. Other books are fine.



If we have called the book from a button, then the
procedure will run without error, but if we then try to
run any code that relates to the forms in this book we
have the difficulties as above.



I do not know if this is related but in the references
window the 'Microsoft Forms 2.0 Object Library' moves a
few slots down the list.



That’s as many clues as we can give, we are not

officially
clueless, anyone out there help?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
xlDialogSendMail problem Gavin Smith[_2_] Excel Programming 1 October 29th 03 05:29 PM
Auto Email via xlDialogSendMail addressing question Jake Marx Excel Programming 0 September 17th 03 05:26 PM
Conflict between xlDialogSendMail and xlDialogPrintPreview Peter Ostermann Excel Programming 5 August 30th 03 10:19 AM
Setting the Send to Value xlDialogSendMail Tammy[_2_] Excel Programming 2 August 19th 03 04:14 PM
xlDialogSendMail O'Neil Excel Programming 0 July 10th 03 03:50 PM


All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"