Error 5479

[Donhuff]

When I run the following MACRO from a VBA form, I get error 5479, cannot
close word because a dialog box is open. I'm not trying to close word (at
least I don't think so). Open_Docs is a MACRO VBA form.

Private Sub CommandButton1_Click()
ChangeFileOpenDirectory "C:\users\dhuffaker\Documents\xmydata\CorpExam\Corp\"
Documents.Open FileName:="DOR.doc"
Application.Dialogs(wdDialogFileSaveAs).Show
Unload Open_Docs
End Sub

 

[Jacob Skaria]

Let us know what you are trying to achieve....

You wanna open a document and save as....
OR
You wanna open a document from dialog box

If this post helps click Yes

 

[Doug Robbins - Word MVP on news.microsoft.com]

Use Me.Hide instead of Unload Open_Docs

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com