Prev: Accessing Autofilter Lists
Next: Queries created by MS Query not in QueryTables collection
From: mdmaremont on 26 Feb 2010 16:15
Excel 2003; Windows XP OS. I have a series of macros in my PERSONAL.XLS
workbook that create a number of different pivot tables. I can't set up to
run automatically, as I must create the datatables daily and they are a
different size each day. The macros must be executed in the order they were
created or they 'bomb'. When I look at the VBA code, each different macro
contains a numbered pivottable reference, reflecting its creation order (e.g.
PivotTable3). Is there a way to make the references valid regardless of the
order in which they are executed?
From: Peter T on 27 Feb 2010 07:49
When you create the PivotTable with code you have the opportunity to give it
your own name, record a macro and look at the arguments, eg
TableName:="<pivotTable-name>"

When you want to refer that PivotTable later

Dim pt As PivotTable
Set pt = ActiveWorkbook.Worksheets("Sheet1").PivotTables("myPvtTble")

Regards,
Peter T


"mdmaremont" <mdmaremont(a)discussions.microsoft.com> wrote in message
news:622E8FA9-B2DB-454C-9EAF-BD765793730A(a)microsoft.com...
> Excel 2003; Windows XP OS. I have a series of macros in my PERSONAL.XLS
> workbook that create a number of different pivot tables. I can't set up
> to
> run automatically, as I must create the datatables daily and they are a
> different size each day. The macros must be executed in the order they
> were
> created or they 'bomb'. When I look at the VBA code, each different macro
> contains a numbered pivottable reference, reflecting its creation order
> (e.g.
> PivotTable3). Is there a way to make the references valid regardless of
> the
> order in which they are executed?


 | 
Pages: 1
Prev: Accessing Autofilter Lists
Next: Queries created by MS Query not in QueryTables collection