Pivot in Macro

[redrose]

How to apply a pivot in a macro???

 

[Andrew Poulsom]

Welcome to MrExcel.

Your question is much too vague. Have you tried recording a macro while doing what you want manually?

 

[redrose]

i have tried applying the pivot ,it is showing error in following lines as
Method "SaveAs" of object '_Workbook' failed :


ActiveWorkbook.SaveAs Filename:="C:\Shwetangi\Tivoli\tivoli_18_June.xls", _
FileFormat:=xlExcel9795, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWindow.Close

 

[Andrew Poulsom]

Why do you need to save as xlExcel9795? Does the path C:\Shwetangi\Tivoli exist?

 

[redrose]

The path does exist,but for saving what should i do????

 

[Andrew Poulsom]

I would omit the FileFormat argument or use xlWorkbookNormal.

 

[redrose]

Thanks!! V'll surely try that out and let u know.....