Exporting data from a .mbe application

[Orion45]

I am currently using code to pass information from the user to an MS Word mail merge. The user brings up the information they want, clicks the export button, selects the form letter they want (listbox), and clicks Merge which then opens the particular form letter with the information they selected. This all works fine with a .mdb version but when I convert to a .mbe, Access won't allow me to export. My code is as follows;
Public Function MergeIt(doc As String)
Dim objWord As Word.Document
doc = "J:\BEA\AppLetters\" & doc
Set objWord = GetObject(doc, "Word.Document&quot
objWord.Application.Visible = True
objWord.MailMerge.OpenDataSource _
Name:="C:\Program Files\PABLE\Database.mde", _
LinkToSource:=True, _
Connection:="QUERY WordMergeParm_qry"
objWord.MailMerge.Execute
End Function
Any thoughts??

 

[hermanlaksko]

In privious ver. of access, access would not allow import of reports etc. if the mdb was changed to an mde.
What version are you using?

 

[BrainB]

I see your code has .mde and you elsewhere refer to .mbe. Regards
BrianB
** Let us know if you get something that works !
================================