Export a Report to Word

[Radman]

After i create a report i want to export it to MS Word but it comes up with an error, <br><br>Saying that: <br>1. It can't output the data to the file i have selected an to<br>&nbsp;<br>a. Check if the file is open (which it is not)<br>b. i am using a templete (i am not)<br>c. the file isn't open and to make sure i have the disk face to do this....<br><br>Basiclly, how can i make it open the file on word as an rtf file.<br>Thanks

 

[famousb]

well, to start at the beginning of your problem...<br>according to your error message you have to have the Word doc open to send to it<br><b><br>Dim WordPath, DocPath, MacroName As String<br>Dim Retval As Variant<br>WordPath = &quot;C:\Program Files\Microsoft Office\Office\WINWORD.EXE&quot;<br>DocPath = &quot;X:\MyDoc.doc&quot;<br>Retval = Shell(WordPath & &quot; &quot; & DocPath, vbMaximizedFocus)<br></b><br>make sure to put in your Word exe path and the name and path of your document.<br><br>personally, i've found exporting a report to Word creates a garbled mess alot of times, it easier to have the report be generated straight to Word, but that's another subject. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[Guest_imported]

I need to export a report to use in a Word file. The report uses lines and rectangles, etc to create a table, but it seems Access will not export lines, rectangles.&nbsp;&nbsp;Is there anyway to work around this.

 

[famousb]

i've found it easier (if you have to do it in Access) to do the report, then export it to adobe acrobat (if you can print to that).&nbsp;&nbsp;Access does not export lines or tables, at least that i've been able to figure out.&nbsp;&nbsp;You could always do the tables in Word, then use an export or mailmerge function to get the data into the tables from Access. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>