Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Debug, Please help
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Debug, Please help
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Debug, Please help
The code can't find tablename or source data is not in R1C1 format.
1) If Table range is a named range then try this from ActiveSheet.PivotTableWizard SourceType:=xlExternal, SourceData:=Sqlstring, tablename:="Table1" to ActiveSheet.PivotTableWizard SourceType:=xlExternal, SourceData:=Sqlstring, tablename:=Range("Table1") 2) Make sure source data is in R1C1 format "Consolidation!R1C1:R2C2" "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Debug this | Excel Programming | |||
help with debug | New Users to Excel | |||
Debug VBA | Excel Programming | |||
* How do we debug this? ... | Excel Programming | |||
No debug box | Excel Programming |