hi. i'm programming a series of macros that will allow me to create pivot tables with external datasources (SQL queruies to a FOX database) dynamically.
this is, i put all the data of the query in cells of a sheet (let's name it "config" sheet), and the macro uses that data to create the pivot table.
i got the program working, but still it needs a lot of work. for that i need to answer a series of questions:
1. I program in Excel 2003, but it doesn't work on Excell 2000. if i translate the code to be 2000-compatible, it won't work in 2003. the most conflictive line is the one with the createpivottable.
the question is: is there any way to know which commands are not backward-compatible, or which ones are compatible with every version?
2. I'm having difficulties to understand how pivotcaches and pivottables work, or how are they related. VBA Help doesn't help a lot. any link to a website with usefull information will be apreciated.
3. one of my routines creates the pivottable, but to do that i need to delete the previous pivottable. however there is no method to do that. how can i delete a pivottable? can i simply overwrite it?
well, that's all. sorry for my english...
Bookmarks