Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
**Urgent help Needed** Run time error 9
Hello, I need help. I created a excel workbook with two sheets. Sheet 1
(AssessmentChart) contains a Pivot chart. Sheet 2 conatins a detail report (DetailReport) with autofilter on. Workbook saved using Excel 97 - 2003 compatability format. Data from connection to SQL Server. I have users of Excel 2003 & 2007. I'm using Chart events to allow me to click on bars in chart to make detail report active and filter it based on the bar that is clicked. This work perfectly for my Excel 2007 users. When my users of Excel 2003 click on a bar they get a Run time Error 9 on the following statement in vba code. ActiveSheet.ListObjects("Table_CRPRDNMSQXXX_Mytabl e_DB001_data_vwDetailRptData").Range. _ AutoFilter Field:=29, Criteria1:=strHoldPassWatchFail strHoldPassWatchFail (data series ) is a global variable that I use to filter the data in my detail report. Table_CRPRDNMSQXXX_Mytable_DB001_data_vwDetailRptD ata is SQL server data source for detail report. Please help not sure what is going on, why my Excel 2003 users are getting error. -- DC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
**Urgent help Needed** Run time error 9
Runtime error 9 usually means that the worksheet that you are referencing
does not exist, check your names carefully for typing errors or spaces etc. Regards, The Code Cage Team www.thecodecage.com/forumz "Dee" wrote: Hello, I need help. I created a excel workbook with two sheets. Sheet 1 (AssessmentChart) contains a Pivot chart. Sheet 2 conatins a detail report (DetailReport) with autofilter on. Workbook saved using Excel 97 - 2003 compatability format. Data from connection to SQL Server. I have users of Excel 2003 & 2007. I'm using Chart events to allow me to click on bars in chart to make detail report active and filter it based on the bar that is clicked. This work perfectly for my Excel 2007 users. When my users of Excel 2003 click on a bar they get a Run time Error 9 on the following statement in vba code. ActiveSheet.ListObjects("Table_CRPRDNMSQXXX_Mytabl e_DB001_data_vwDetailRptData").Range. _ AutoFilter Field:=29, Criteria1:=strHoldPassWatchFail strHoldPassWatchFail (data series ) is a global variable that I use to filter the data in my detail report. Table_CRPRDNMSQXXX_Mytable_DB001_data_vwDetailRptD ata is SQL server data source for detail report. Please help not sure what is going on, why my Excel 2003 users are getting error. -- DC |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
**Urgent help Needed** Run time error 9
thanks for reply Code Cage Team, I check names everything checks out. I
have 30 columns in detail report. three are hidden. could this be causing a out of range condition when I try filtering on column 29? -- DC "The Code Cage Team" wrote: Runtime error 9 usually means that the worksheet that you are referencing does not exist, check your names carefully for typing errors or spaces etc. Regards, The Code Cage Team www.thecodecage.com/forumz "Dee" wrote: Hello, I need help. I created a excel workbook with two sheets. Sheet 1 (AssessmentChart) contains a Pivot chart. Sheet 2 conatins a detail report (DetailReport) with autofilter on. Workbook saved using Excel 97 - 2003 compatability format. Data from connection to SQL Server. I have users of Excel 2003 & 2007. I'm using Chart events to allow me to click on bars in chart to make detail report active and filter it based on the bar that is clicked. This work perfectly for my Excel 2007 users. When my users of Excel 2003 click on a bar they get a Run time Error 9 on the following statement in vba code. ActiveSheet.ListObjects("Table_CRPRDNMSQXXX_Mytabl e_DB001_data_vwDetailRptData").Range. _ AutoFilter Field:=29, Criteria1:=strHoldPassWatchFail strHoldPassWatchFail (data series ) is a global variable that I use to filter the data in my detail report. Table_CRPRDNMSQXXX_Mytable_DB001_data_vwDetailRptD ata is SQL server data source for detail report. Please help not sure what is going on, why my Excel 2003 users are getting error. -- DC |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
**Urgent help Needed** Run time error 9
There appears to be only two things that it would not find. One is the
ActiveSheet and I think we can eliminate that one as a problem. The other is your detail report data. If it has not been added to the ListObjects collection, that could be the problem. But I am only guessing. Somehow it is not making the connection to the object references in that statement. "Dee" wrote: thanks for reply Code Cage Team, I check names everything checks out. I have 30 columns in detail report. three are hidden. could this be causing a out of range condition when I try filtering on column 29? -- DC "The Code Cage Team" wrote: Runtime error 9 usually means that the worksheet that you are referencing does not exist, check your names carefully for typing errors or spaces etc. Regards, The Code Cage Team www.thecodecage.com/forumz "Dee" wrote: Hello, I need help. I created a excel workbook with two sheets. Sheet 1 (AssessmentChart) contains a Pivot chart. Sheet 2 conatins a detail report (DetailReport) with autofilter on. Workbook saved using Excel 97 - 2003 compatability format. Data from connection to SQL Server. I have users of Excel 2003 & 2007. I'm using Chart events to allow me to click on bars in chart to make detail report active and filter it based on the bar that is clicked. This work perfectly for my Excel 2007 users. When my users of Excel 2003 click on a bar they get a Run time Error 9 on the following statement in vba code. ActiveSheet.ListObjects("Table_CRPRDNMSQXXX_Mytabl e_DB001_data_vwDetailRptData").Range. _ AutoFilter Field:=29, Criteria1:=strHoldPassWatchFail strHoldPassWatchFail (data series ) is a global variable that I use to filter the data in my detail report. Table_CRPRDNMSQXXX_Mytable_DB001_data_vwDetailRptD ata is SQL server data source for detail report. Please help not sure what is going on, why my Excel 2003 users are getting error. -- DC |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
**Urgent help Needed** Run time error 9
OK, I will check detail sheet. I still don't understand why Excel 2007
does not an issue. -- DC "JLGWhiz" wrote: There appears to be only two things that it would not find. One is the ActiveSheet and I think we can eliminate that one as a problem. The other is your detail report data. If it has not been added to the ListObjects collection, that could be the problem. But I am only guessing. Somehow it is not making the connection to the object references in that statement. "Dee" wrote: thanks for reply Code Cage Team, I check names everything checks out. I have 30 columns in detail report. three are hidden. could this be causing a out of range condition when I try filtering on column 29? -- DC "The Code Cage Team" wrote: Runtime error 9 usually means that the worksheet that you are referencing does not exist, check your names carefully for typing errors or spaces etc. Regards, The Code Cage Team www.thecodecage.com/forumz "Dee" wrote: Hello, I need help. I created a excel workbook with two sheets. Sheet 1 (AssessmentChart) contains a Pivot chart. Sheet 2 conatins a detail report (DetailReport) with autofilter on. Workbook saved using Excel 97 - 2003 compatability format. Data from connection to SQL Server. I have users of Excel 2003 & 2007. I'm using Chart events to allow me to click on bars in chart to make detail report active and filter it based on the bar that is clicked. This work perfectly for my Excel 2007 users. When my users of Excel 2003 click on a bar they get a Run time Error 9 on the following statement in vba code. ActiveSheet.ListObjects("Table_CRPRDNMSQXXX_Mytabl e_DB001_data_vwDetailRptData").Range. _ AutoFilter Field:=29, Criteria1:=strHoldPassWatchFail strHoldPassWatchFail (data series ) is a global variable that I use to filter the data in my detail report. Table_CRPRDNMSQXXX_Mytable_DB001_data_vwDetailRptD ata is SQL server data source for detail report. Please help not sure what is going on, why my Excel 2003 users are getting error. -- DC |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
**Urgent help Needed** Run time error 9
Could this be a data connection issue?
-- DC "Dee" wrote: OK, I will check detail sheet. I still don't understand why Excel 2007 does not an issue. -- DC "JLGWhiz" wrote: There appears to be only two things that it would not find. One is the ActiveSheet and I think we can eliminate that one as a problem. The other is your detail report data. If it has not been added to the ListObjects collection, that could be the problem. But I am only guessing. Somehow it is not making the connection to the object references in that statement. "Dee" wrote: thanks for reply Code Cage Team, I check names everything checks out. I have 30 columns in detail report. three are hidden. could this be causing a out of range condition when I try filtering on column 29? -- DC "The Code Cage Team" wrote: Runtime error 9 usually means that the worksheet that you are referencing does not exist, check your names carefully for typing errors or spaces etc. Regards, The Code Cage Team www.thecodecage.com/forumz "Dee" wrote: Hello, I need help. I created a excel workbook with two sheets. Sheet 1 (AssessmentChart) contains a Pivot chart. Sheet 2 conatins a detail report (DetailReport) with autofilter on. Workbook saved using Excel 97 - 2003 compatability format. Data from connection to SQL Server. I have users of Excel 2003 & 2007. I'm using Chart events to allow me to click on bars in chart to make detail report active and filter it based on the bar that is clicked. This work perfectly for my Excel 2007 users. When my users of Excel 2003 click on a bar they get a Run time Error 9 on the following statement in vba code. ActiveSheet.ListObjects("Table_CRPRDNMSQXXX_Mytabl e_DB001_data_vwDetailRptData").Range. _ AutoFilter Field:=29, Criteria1:=strHoldPassWatchFail strHoldPassWatchFail (data series ) is a global variable that I use to filter the data in my detail report. Table_CRPRDNMSQXXX_Mytable_DB001_data_vwDetailRptD ata is SQL server data source for detail report. Please help not sure what is going on, why my Excel 2003 users are getting error. -- DC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004' . Please help. Urgent | Excel Programming | |||
Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error | Excel Programming | |||
Urgent - running time error type mismatch | Excel Programming | |||
Run Time Automation Error - Help Needed | Excel Programming | |||
Automation Error ... Urgent help needed | Excel Programming |