R
Rycho
Hi there,
I'm connecting PivotTable to OLAP Cube on the server:
<script language="VBScript">
OLAPProvider = "Provider=................"
OLAPCube = "Sales"
Function start()
PivotTable.ConnectionString = OLAPProvider
PivotTable.DataMember = OLAPCube
End Function
</script>
then i'm building "my PivotTable" and here is a question:
how to export it to xml file whitch can be imported once again?
when i'll export it to Excel, it's building PivotTablexxxx.HTM file in
Temp, then Excel is reading this file, but how to import it into blank
PivotTable?
When i'm trying to import this file there is an error: Error opening
data file "file://c:\myfile.htm"
to import this file i'm using this script:
<script language="VBScript">
providerPivotTable = "provider=mspersist"
strdirname = "c:\myfile.htm"
Function start()
PivotTable.ConnectionString = providerPivotTable
PivotTable.CommandText = strdirname
End Function
</script>
What's wrong with this? Any ideas?
I have tried also to save this file from excel in .csv and .xml format,
but it's not working anyway.
Please help,
Richard
I'm connecting PivotTable to OLAP Cube on the server:
<script language="VBScript">
OLAPProvider = "Provider=................"
OLAPCube = "Sales"
Function start()
PivotTable.ConnectionString = OLAPProvider
PivotTable.DataMember = OLAPCube
End Function
</script>
then i'm building "my PivotTable" and here is a question:
how to export it to xml file whitch can be imported once again?
when i'll export it to Excel, it's building PivotTablexxxx.HTM file in
Temp, then Excel is reading this file, but how to import it into blank
PivotTable?
When i'm trying to import this file there is an error: Error opening
data file "file://c:\myfile.htm"
to import this file i'm using this script:
<script language="VBScript">
providerPivotTable = "provider=mspersist"
strdirname = "c:\myfile.htm"
Function start()
PivotTable.ConnectionString = providerPivotTable
PivotTable.CommandText = strdirname
End Function
</script>
What's wrong with this? Any ideas?
I have tried also to save this file from excel in .csv and .xml format,
but it's not working anyway.
Please help,
Richard