ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pivot and vba (https://www.excelbanter.com/excel-programming/329587-pivot-vba.html)

filipus[_3_]

pivot and vba
 

I am trying hard to get into it...
The documentation is not realy good on this!
Knows somebody a webpage or a very good book
which explains this stuff more in detail?

trial and error method is very time consuming...

did you have once a look how big this pivotTable object
is. many properties and methods...

this object catalog is not very helpful as well

in the help docu you can read something like that:
"programming of pivot tables are very complicated! Try to figure
out how it works by using the macro recorder!!!!"

hahahaha

I know that MS-interna are always difficult...

cheers,

filipu

--
filipu
-----------------------------------------------------------------------
filipus's Profile: http://www.msusenet.com/member.php?userid=125
View this thread: http://www.msusenet.com/t-187043920


Ken Wright

pivot and vba
 
http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"filipus" wrote in message
...

I am trying hard to get into it...
The documentation is not realy good on this!
Knows somebody a webpage or a very good book
which explains this stuff more in detail?

trial and error method is very time consuming...

did you have once a look how big this pivotTable object
is. many properties and methods...

this object catalog is not very helpful as well

in the help docu you can read something like that:
"programming of pivot tables are very complicated! Try to figure
out how it works by using the macro recorder!!!!"

hahahaha

I know that MS-interna are always difficult...

cheers,

filipus


--
filipus
------------------------------------------------------------------------
filipus's Profile: http://www.msusenet.com/member.php?userid=1258
View this thread: http://www.msusenet.com/t-1870439207





All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com