Your newsreader or web site interface may have introduced errors. Post your email (with the @
replace by AT) and I will send you a working version.

HTH,
Bernie
MS Excel MVP


"Hru48" wrote in message
...

hmm I changed it from

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase,

to

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase,


but now I get an invalid proceedure, call or argument error


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=558821