Hallo zusammen,
ich versuche mit Lotus Script die Source-Daten einer Pivottabelle zu ändern.
Leider bekomme ich beim With die Fehlermeldung "Instance member PIVOTTABLEWIZARD does not exist".
Hier noch der Quellcode:
Code
Dim ws As New NotesUIWorkspace
Dim excelApp As Variant
Dim ExcelWorkbook As String
Dim files As Variant
files = ws.OpenFileDialog(True, "File List", "", "C:\")
If Isempty(files) Then
Exit Sub
End If
Forall filelist In files
ExcelWorkbook = Cstr(filelist)
Set excelApp = CreateObject("Excel.application")
excelApp.Visible = True
excelApp.Workbooks.open(ExcelWorkbook)
With excelApp.PivotTableWizard
.SourceType= 1
.SourceData = "Basis!R1C1:R116C19"
End With
excelApp.quit
Set excelApp = Nothing
End Forall
Msgbox "Fertig!!"
Alles anzeigen
Danke schonmal!
Gruß Stony