Mailmerge causing send to microsoft error

[SQLScholar]

Hey all,

I have a new laptop (well new to me!). It has office 2002.

Previously all developers of our software has word 2k. End users have a mixture.

Now our Vb6 app triggers a mailmerge (for office 2K and above we have done the security registry change).

All seems well - apart from if i compile on my laptop when the mailmerge is triggered it crashes the app and does a "send to microsoft". If i trigger it on my laptop all seems fine.

If i compile it on the old PC (word 2k) no one complains of errors. I dont know where to start to sort this out.

Any ideas?

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[dglienna]

You want to use Late Binding:

<code>
Option Explicit
' These are both examples of Late Binding

Public Sub RunAccessMacro(strDB As String, strMacro As String)
'================================================================
'for late binding declare it As Object and use CreateObject() function
Dim AccessDB As Object
Set AccessDB = CreateObject("Access.Application")

With AccessDB
.OpenCurrentDatabase strDB
.DoCmd.RunMacro strMacro, 1
'.Visible = True 'you decide
.CloseCurrentDatabase
End With
Set AccessDB = Nothing

End Sub

Public Sub ExcelMacro()
Dim excl As Object
Dim wrbk As Object

Set excl = CreateObject("Excel.Application")
excl.DisplayAlerts = False
Set wrbk = excl.Workbooks.Open("myfile", , True, , "mypassword")
excl.Run "MacroName", "arg1", "arg2"
End Sub
</code>



-David
2006, 2007 & 2008 Microsoft Most Valuable Professional (VB)
2006 Dell Certified System Professional (CSP)