Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros in PERSONAL.XLS
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros in PERSONAL.XLS
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("m yPvtTble") Regards, Peter T "mdmaremont" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list using macros in a personal macros workbook | Excel Programming | |||
Macros always available in Personal.xls? | Excel Programming | |||
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
Personal.xls Macros? | Excel Programming | |||
Personal.xls Macros | Excel Programming |