Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Counting String in an Array
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... -
Counting String in an Array
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 <... -
Chart Axis Text
BINGO! That did it. (sunofa.....) Thanks for all the assistance. -
Chart Axis Text
I'm going to say no. Everything dealing with Excel is listed above. -
Chart Axis Text
mm, not sure what you mean. I'm not sure what the constant for 'xlCategory' would be -
Chart Axis Text
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 -
Chart Axis Text
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)'. -
Chart Axis Text
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... -
Chart Axis Text
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' -
Chart Axis Text
LOL, ok, that's what I thought. Duh, I just caught the missing 'End With' -
Chart Axis Text
I left this is .. [Query_from_Excel_Files] Should it be replaced with something else? -
-
Chart Axis Text
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... -
Chart Axis Text
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... -
Counting multiple occurances in an array
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'... -
Counting multiple occurances in an array
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")... -
Counting multiple occurances in an array
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... -
Excel Chart References for VBA (vbScript)
I think that will do the trick. Thanks- JohnCR
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Chart References for VBA (vbScript)
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...- JohnCR
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Type Mismatch with GetRows
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 =...
