Debug, Please help
Can you show a sample of the SQL that you are referreing to? Maybe record a
macro while manually creattig the table and posting the code.
"Michael" wrote:
On Aug 20, 5:04 pm, Michael wrote:
Hi,
Could anyone please help with the following code. When I ran it, it
said: "Error 1004"
ActiveSheet.PivotTableWizard SourceType:=xlExternal,
SourceData:=Sqlstring, tablename:="Table1"
Thanks a lot!!
Michael
I figured out the code now. Now Could anyone please post some code
when I wanan change the SQL in an existing pivottable to get it
refreshed? Thanks a lot. Mike
|