Search results for query: *

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'...

Well your example does work, TomThumb, however I need to get the date from a recordset. BTW, I'm impressed. I've been working on this for a few days. Thanks! This is what I have at the moment Dim sSQL Dim connection Dim rs Dim cn Dim i Set objFSO = CreateObject("Scripting.FileSystemObject")...

Hello, I'm trying to find the best way to count elements of an array. I have any number of occurances of dates, such as mm/dd/yy and I would like to count the seperate occurances so that I can plot them on a chart. The data I'm currently working with is; 7/6/04 7/6/04 7/6/04 7/5/04 7/5/04...

I think that will do the trick. Thanks

Hello, I'm not certain which forum this would go in. So if it's wrong, I apoligize. I'm wondering if anyone has any references to the excel formatting commands that would be used in VBA (or vbscript). I have a script that is working and I would like to add instructions for another...

Hello, I'm getting a "Type Mismatch" in this snippet of code. I'm hoping someone might be able to explain it ... Dim rsTestlog Dim arSta() Dim arVer() Set objFSO = CreateObject("Scripting.FileSystemObject") sSQL = "SELECT Status, Version FROM TestLog" Set connection =...