Build Pivot on CSV using VBA

Hi

I have built an MS Access front end which can export filtered data to CSV's from a database. The users then want to pivot this data using Excel..

We are still using Office 2003 here, and typical export will be more than 65k rows..

I now want to automate the next step of creating a new workbook file and building a pivot table within this file that connects to the CSV data..

I am able to write code that creates an excel file, and also build a pivot on data within the workbook... However, I have not been able to find on the forums how to connect a pivot to an external datasource using VBA..

Any ideas?

Hi Guys

Here is the code I have at the moment, but it keeps failing on the line '.CreatePivotTable'

Can anyone help with this ?

Please Login or Register  to view this content.

SOLVED !!

Thanks Jo !!

That works perfectly !!