Stuart McLachlan
stuart at lexacorp.com.pg
Tue May 3 15:49:36 CDT 2011
If the parameter in the sp is some sort of string, as suggested by '" & "M" & "'", try conTest.Execute "EXEC sp_Add_FutureServicesOrders_byRoute '" & Trim$(RTE) & "'" i.e. embed RTE in single quotes and trim the leading space placeholder for "+/-" -- Stuart On 3 May 2011 at 11:05, b heygood wrote: > 'conTest.Execute "sp_Add_FutureServicesOrders_byRoute '" & "M" & "'" > conTest.Execute "EXEC sp_Add_FutureServicesOrders_byRoute " & RTE > >