Create Pivot table in excel thro' R5

[pechettysuguna]

Hi,

How to create a Pivot table of the data which is in excel file thro' Lotus notes designer R5?

Firstly, on click of a button -> creates a excel file with the required date.
Now, after the data is exported, how to create a pivot table of that data.
thanks.
Suguna

 

[pmonett]

Isn't that something that an Excel macro would do better ? Besides, if you have instructions to do it in Excel, how can you trigger it in Notes ?

Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

 

[Rofeu]

Hi,

you use the GetObject method to get the workbook:

 Dim AppXLwb As Variant

Set AppXLwb = GetObject("C:\TEST.xls", "Excel.Workbook")

With AppXLwb
 
 'Your Code Here
 
 .Close
End With


Set AppXLwb = Nothing

AppXLwb behaves as a regular Excel workbook as far as I know.

Cheers,

Roel

 

[Rofeu]

sorry, "Excel.Workbook" needs to be "Excel.Sheet". It does behave a workbook though.

Cheers,

Roel