Hello, This seems so simple but I cant figure it out for the life of me, I have a dropdown option list with 1-50 in it and I would like to update a variable named zQty with which number in the dropdown was selected by the user so I can use it when I am ready.
Thanks and sorry if this is a dumb...
dim temp as string
dim tempArray() as string
open "c:\mydir\myText.txt" for input as #1
do while eof(1) = false
Line Input #1, temp
temparray = split(temp,",")
loop
Hope this helps!!!
Hungoverhippie
Glad I could Help maybe you can take a quick look at my question posted called String Help Rephrase see if you can see what I am missing .. :)
Thanks
Hungoverhippie
arrPayRules(intX, 2) = CStr(rsDailyLabor.Fields("OutTime").Value) '***ERRORS HERE AT (5,2)
arrPayRules(intX, 2) where is that array dont you want
arrSchedules(intX, 2) instead
Hope this helps!!
Hungoverhippie
where another example of the same thing i am trying to get working...
This fails reading the select statement from file but works if hardcoded
Dim cnn2 As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strng As String
Set cnn2 = New ADODB.Connection
cnn2.ConnectionString =...
No need to read from a text file for this project. put differently I need to how to make a$=ary(10) equal the liternal statement in that array not the string of it..
Thanks
I need to make a literal out of a string.
Example:
*'Textfile Data reads as follows
rst1.fields("test1")
rst1.fields("test2")
dim ary(2)
open "c:\mydir\testfile.txt" for input as #1
for x=1 to 2
line Input #1, ary(x)
Next x
close #1
'all my ado connection stuff...
Ok theres got to be away to do this,
reading from a text File and the lines read
rst1.fields("test")
rst1.fields("test2")
I read these into an array then I do my select statement and Open from my sql database no problem but then how can i assign from my recordset that is...
Is there a way in Excel VBA to add the references I need loaded on the fly. I have done a few excel macros that talk to my sql databases but everytime I give it to someone I have to go load all the references by hand that the macro needs before it will run for them.. Sorry may be a simple...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.