[AccessD] Writing To Excel From Access Code

To all,

I have an access database which grabs a certain recordset containing JobNo, StartTime, PrintAddress and EmployeeRole and writes out to an Excel spreadsheet.  I am using the following code to put the fields together

strDayWork = JobNo &  "                      " & StartTime & vbcrlf & PrintAddress & vbcrlf & EmployeeRole

and uses the command .Cells(intExcelRow, intExcelCol) = strDayWork to put the data in the specific cell.  

The problem is the CTRL characters for the return code also show up in Excel, does anyone know a way of how to remove these from the Excel view.

Thanks in advance for all your help..

Paul Hartland

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm