B
bob_dotnet
I've inherited the task of putting some (stored_procedure) data driven
pivottables onto our intranet and I'm running into some really basic
obstacles. So I'm hoping that someone can tell me where I've wandered
off the correct path or can point me to some sample code so I can make
this work.
I have an excel workbook with 2 worksheets in it.
1. Holds the pivottable that reads data from the second sheet.
2. Holds the data which is pointing at a stored_proc.
I need to have Sheet 2's data updated before the pivottable is visible.
I've opened the sheet in Excel and saved it as a Web Page and have
added interactivity.
I'm using the owc11 Web Components.
Is this even the correct way to go about doing this? The few examples
that I see only show VBScript code for connections, but I don't see
where the 2 (OWC and VBScript) meet.
Does anyone have some sample code that does what I'm doing using data
out of Northwind? I think, because of the lack of answers via the web
that I'm going about this the wrong way and am hoping someone can point
me down the correct path.
TIA,
Bob
pivottables onto our intranet and I'm running into some really basic
obstacles. So I'm hoping that someone can tell me where I've wandered
off the correct path or can point me to some sample code so I can make
this work.
I have an excel workbook with 2 worksheets in it.
1. Holds the pivottable that reads data from the second sheet.
2. Holds the data which is pointing at a stored_proc.
I need to have Sheet 2's data updated before the pivottable is visible.
I've opened the sheet in Excel and saved it as a Web Page and have
added interactivity.
I'm using the owc11 Web Components.
Is this even the correct way to go about doing this? The few examples
that I see only show VBScript code for connections, but I don't see
where the 2 (OWC and VBScript) meet.
Does anyone have some sample code that does what I'm doing using data
out of Northwind? I think, because of the lack of answers via the web
that I'm going about this the wrong way and am hoping someone can point
me down the correct path.
TIA,
Bob