Thanks for the info. All I want to do is pass the data to a form and print it out Have you used it?
Peter
>You need to use oInfoPath = CREATEOBJECT("Infopath.ExternalApplication"). > >From http://msdn.microsoft.com/library/en-us/ipsdk/html/ipsdkIntroducingInfoPathDevelopment.asp?frame=true > >A major difference between the InfoPath object model and other Office application object models is that the InfoPath object model does not support full automation. You cannot use the InfoPath object model to programmatically create an InfoPath form. However, the InfoPath object model does provide the ExternalApplication object, which can be used to perform a limited set of operations within InfoPath such as opening, registering, and closing a form. > > >