Rowan Drummond <rowanzsaNotThis@hotmail.com> wrote in
news:OOqTAcC4FHA.4076@TK2MSFTNGP15.phx.gbl:

> When you declare variables like this:
> Dim test1, test2, test3 As String
> only test3 is declared as a String. test1 and test2 will be assigned
> the DataType Variant. UpdateAll is looking for a variable with a
> string datatype.
>
> Change your decleration to
> dim test1 as string, test2 as string, test3 as string
>
> or
> Dim test1 as string
> dim test2 as string
> dim test3 as string
>
> Hope this helps
> Rowan

Gah! Yes, that helps.

fyb