Publish Form Results as a Report in Excel and Word using Macro

[jainson]

Hi All,

I am trying to create a report that dynamically produces the results of a form which has a few queries and then I want to publish this report both in excel and pdf. Is there a macro that can help me do the same.

Thanks!!

 

[jasmith4]

Not much detail here, so all I can think of is using Access's Tools/OfficeLinks (v<=2003) or the various tools on the External Data ribbon (v>=2007). For PDF rather than Word, you'll need Adobe Acrobat, or Adobe Distiller at a minimum.