| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating New Workbook from Sheet
You are welcome
Seems the recorder in 2007 is not working correct Time that I play more with this stuff (if I have time) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ozzie via OfficeKB.com" <u18021@uwe wrote in message news:a25d2285da8ed@uwe... Ron de Bruin wrote: This is working in 2003 ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _ WSNew.UsedRange).CreatePivotTable TableDestination:= _ SecondSh.Range("A1"), TableName:="PivotTable2", DefaultVersion:= _ xlPivotTableVersion10 Hi Ozzie [quoted text clipped - 47 lines] it just doesn't like the creating of the pivot Ron, Thank you very much, it all works very, very well, really appreciated -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a list from another sheet or workbook | Excel Discussion (Misc queries) | |||
| creating a excel sheet and have it print out and also load theinformation into another workbook | Excel Programming | |||
| creating new workbook from one sheet | Excel Programming | |||
| Creating new sheet named one week newer that active sheet | Excel Programming | |||
| Q: Creating a macro to sort and group columns in a sheet according to another sheet | Excel Programming | |||
Hybrid Mode
