Fixing a Pivot table problem in a VBA program (055)

Fixing a Pivot table problem in a VBA program (055) The zip file contains a simple XLS file ([login to view URL]) which has a single worksheet called “Transactions?? from which I wish, as an example, to produce a pivot table. This should be easy for someone with a detailed understanding of the Pivot objects. There are two VBA routines Test1 and test2 Test1 has been created with the macro recorder and works fine. If you delete all sheets (except “Transactions?? and then go tools -> Macro, you will see Tst1 and test2 in Module1. Go into Test1 and execute it (F5). It produces a pivot table. Now delete the table and go into Test2 and execute it. It fails. The difference between Test1 and Test2 is that in Test2, I have replaced all the literal strings with string variables. These all work except the PageFields part of the statement below: [login to view URL]("PivotTable1").AddFields RowFields:=strrowfields, _ ColumnFields:=strcolumnfields, PageFields:=Array(strpagefields) Your task is to provide a way of adding page fields through variables and producing a version of Test2 that is driven entirely by string variables with no literal strings. I suspect it is to do with the way that strpagefields is constructed ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows