Thread: Need code assistance to update pivot table from an ADO recordset
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bryan S[_2_] Bryan S[_2_] is offline
external usenet poster
  
Posts: 2
Default Need code assistance to update pivot table from an ADO records
Have tried that and variations of setting cache = recordset, but all give
errors.
Thanks for your help


"TomPl" wrote:

Sorry, but I am in over my head on this.

Have you tried to add the code "ActiveSheet.PivotTables("Test
PT").PivotCache.Refresh" to your code following "Set objPivotCache.Recordset
= objRS" but before closing the database?

Tom

Reply With QuoteReply With Quote