tstbuddy

Hello, I would like to create a report that displays the information in Excel or Word. I tried using the DataReport Designer but it only exports the data or HTML or text. I do not want the user to have to go int o excel or word and import the document (many user steps). Is there a way to create the report in VB using MS Excel or MS Word?

Anis

Chekc out this http://www.xtremevbtalk.com/show...threadid=16520 in Code Library

tstbuddy

Thank you for the link. The example project works with Excel but I cannot get the Word Report Example to compile. I receive an error stating: Compile Error: Wrong number of arguments or invalid property assignment. Did you get this code to work?