Create pivot table based on array in memory

**JasperD** · 01-22-2015, 08:13 AM

Hi guys,

I've got an auto-updated CSV file on a server, that I want to pull into an array in memory via a macro.
That seems straightforward enough, but then when I have the array in memory, I'd like to create a pivot table in my worksheet based on that memory array.

Is this possible? If so, does anyone have any pointers on how to go about this?

Many thanks in advance!

Jasper

**JasperD** · 01-22-2015, 10:21 AM

anyone?
I can't understand why the following just doesn't work...

Please Login or Register  to view this content.

**romperstomper** · 01-22-2015, 11:41 AM

SourceData must be a range if type is xlDatabase. You could extract the data into a recordset using ADO and then assign that to the pivot cache, but you can't use an array.