View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Parameters.Refresh

So you are not getting the error that is shown in the article? Do you get
that error if you use Refresh?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Jim Heavey" wrote in message
...
Bob, I have tried several versions of what you had suggested. Seems
perfectly logical, but it does not work. When the append command is used,

I
get an error message about requiring an object.

I have gone and seen KB article from Microsoft which shows the use of
refresh method, and once that is used, the code begins to reference the
parameters, so I am guessing that the Refresh initialized those parameters

in
the command object.

But neither work for me.