Create a pivot table in VBA and after running it should be in only values and text format

hi

i am new to VBA and i can create a pivot table normally and i copy the pivot table and using paste special i paste only the value but i need to use it with VBA
Precisely
1) i have three columns A,B and C and i need to make a pivot table in which Column A is in Row Label
2) while coulmn B is in Column Label
3) and Column C is in Values and column C should appear in with Sum function
4) finally that pivot table should be in text and values format not in pivot table format..

Thanx in Advance

Any body help me plzzzzz...