View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TOMD TOMD is offline
external usenet poster
 
Posts: 33
Default Pivotcaches add method

Hello,

I am trying to create a pivot table in Excel from an Access table. I am
having trouble with the pivot caches add method. The M/S help screen tells me
to use the following format:

expression.Add (source type, source data)

but I can't find a section in help that explains what I need to specify for
source type & source data.

Could someone explain this to me and also, is there a better way of using
Help? I get to the expressions and frequently get lost. (I'm new at
programming, just finished the M/S Press Excel VBA Step by Step).

Thanks in advance,


--
TomD