Recent content by JohnCR

Thanks wangdog! I dont quite understand what this line is doing ... countCat = animalSingle[i].equals("Cat")?countCat+1:countCat+0; Specifically, I dont understand this .... ?countCat+1:countCat+0; Also, I'm seriously confused about the whole array/arrayList/vector/hash things. There are a...

Hello All, I'm hoping someone can help here. I'm trying to count how many times a string occurs in an array. Here is the code I have ... String animals[] = {"Cat", "Cat", "Dog", "Dog", "Fish"}; String animalSingle[] = {"Cat", "Dog", "Fish"}; count = 0; for (int i = 0; i <...

BINGO! That did it. (sunofa.....) Thanks for all the assistance.

I'm going to say no. Everything dealing with Excel is listed above.

mm, not sure what you mean. I'm not sure what the constant for 'xlCategory' would be

The version of Excel maybe? I have Office 2003. But looking in the MS Visual Basic editor it appears I'm entering it correctly. Odd

hmm, I'm not sure how you are getting this to work. I keep getting flagged on the 'With .Axes(xlCategory)' line. This only way I get passed it is to remove the '(xlCategory)'.

This is what I have .. ' Create Excel object and first chart t = 0 intI = 1 intJ = 1 Dim xlstrCount(25) Dim xlapp Dim wb Dim objsheet1 Dim objChart1 Set xlapp = createobject("Excel.Application") xlapp.Application.Visible = False Set wb = xlapp.workbooks.add Set...

I can get passed the line if I remove the (xlCategory) from the With .Axes. But then that results in another error "Object Doesn't supprt this property or method: 'HasTitle'

LOL, ok, that's what I thought. Duh, I just caught the missing 'End With'

I left this is .. [Query_from_Excel_Files] Should it be replaced with something else?

hm, it doesn't like the 'SetSourceData' line.

I believe a "CHART SHEET". Here's everything I have at the moment for the chart ... Set xlapp = createobject("Excel.Application") xlapp.Application.Visible = False Set wb = xlapp.workbooks.add Set objsheet1 = xlapp.Worksheets(1) objsheet1.Name = "Data" For Each strDate In...

I'm trying to label a chart axis with this ... Set objAxis = xlapp.ActiveChart.Axes(xlValue, xlPrimary) With objAxis .HasTitle = True .Title.Text = "Issues" End With And I keep getting a Unable to get the Axis property of the Chart class, Code 800A03EC. Does anyone haev any idea what I'm...

Well I considered the database 'Select' option but I'm using other parts of the database in other areas of the script. The modification should work just fine. I've tested this little bit of code and will add it to the complete script later today. Is it possible to have multiple 'Select'...