Search:
Type: Posts; User: rjhe22
Search:
Search took 0.03 seconds.
-
March 7th, 2014, 07:34 AM
would this work
For iRow = 2 To maxRow
MessageBox.Show("This is column " & objSht.Cells(iRow, maxCol).Value)
strCol = Chr(Asc(iCol) + 16)
...
-
March 7th, 2014, 06:26 AM
hi
i have this code that reads an excel file matches dates and what i need to do it get it to write to another excel file one the date macthes.
Dim objExcel As New Excel.Application
...
-
August 14th, 2012, 09:22 AM
sorry bout double post
what i mean about medium is say my values coming in are 16, 16, 10 medium is 16 if the values come in are 10, 8, 9 medium is 8
i get what you mean bout the sql but there...
-
August 14th, 2012, 08:35 AM
-
August 14th, 2012, 06:12 AM
hi
i have to get this arraydone and im stuck any help would be great
the first part of code reads the info from a table and writes it to a text file
Private Function MidRange()
On Error...
-
June 18th, 2012, 07:59 AM
thanks will give it a go.
info will be deleted from table each time we do an add.
-
June 18th, 2012, 04:02 AM
hi the part im missing alot is really the part im stuck on.
for this part
It should be
Cmd$ = "Insert Into TableName ( Your field names as above) Values ( The actual values for each field...
-
June 15th, 2012, 08:19 AM
really stuck on this can anyone help
-
June 15th, 2012, 08:17 AM
it moves the file from the c to the h driv. i decided to leave out the delete foir now.
do u think its wrong?
it seem to work the moving of it from 1 location to another
-
June 15th, 2012, 06:54 AM
Dim FileSystemObject As Object
Set FileSystemObject = CreateObject("Scripting.FileSystemObject")
FileSystemObject.CopyFile "c:\file.txt", "H:\file.txt"
-
June 15th, 2012, 06:36 AM
hi
anyone no how to pick up a file in 1 location and put it into a folder in another while deleting the old file in folder
if the files are in different locations
like say a c drive to an f drive
-
June 15th, 2012, 06:35 AM
hi
this is my code for pulling the info from the excel spreadsheet
is seem to work so happy days
Dim xl As New Excel.Application
Dim xlsheet As Excel.Worksheet
-
December 2nd, 2011, 05:51 AM
i have this bit of code
If CDbl(sAmount) < 0 Then
If CDbl(sAmount) < 0 Then ' (MTRBC_ARRAY$(MTRBC_CCYAMOUNT)
SNEX_ARRAY$(EXE_CD) = "D"
Else
...
-
November 18th, 2011, 11:32 AM
i no i can but the problem is i dont no how many zeros i need for each line some number will be longer than other so wont require as many zeros
-
November 18th, 2011, 09:50 AM
thanks that worked
just need to do one more thing
basically i need the length of the amount to be 37 for all numbers
so if the fist amount has 10 numbers need to have 27 zeros before it
and if...
-
November 18th, 2011, 05:57 AM
hi im trying to get this number -38,842,7450.71
with 38842745071
im using this line to do it Replace(MTRBC_ARRAY$(MTRBC_CCYAMOUNT), ",", "")
now that has taken the , out but how do i get it to...
-
November 11th, 2011, 10:50 AM
Dim j As Integer
Dim sOut As String
Close #17
Open OPXCOM$ + "\tmpTB01.csv" For Input As #17
'*** Architecture call to get record from data base
Do While Not...
-
November 8th, 2011, 10:35 AM
it was but now it has changed just doing what im told at the min
ya i tried that but it doesnt seem to be working
Cmd$ = "SELECT * " + CRLF$
Cmd$ = Cmd$ + " FROM MTRBC_ARRAY$" + CRLF$
...
-
November 8th, 2011, 09:48 AM
can anyone help with this
-
November 8th, 2011, 06:47 AM
i have my loop done for the csv file
Dim j As Integer
Dim sOut As String
Close #17
Open OPXCOM$ + "\tmpTB01.csv" For Input As #17
Do While Not (EOF(17))
-
November 8th, 2011, 05:31 AM
hi
im trying to delete all the info from a table through code
here is what i have done but it wont delete from table
Private Function ReadQueryResults()
start
Cmd$ =...
-
November 4th, 2011, 04:13 AM
well i was asked to loop through csv file first. a table might come into it later but at the moment it wont.
and i cant insert it into a table as i dont have the rights on the db they use here to...
-
November 3rd, 2011, 04:24 AM
i cant because as far as i no it wont be going into a table.
i need to do it as an array like i did it when i was pulling the info from the db.
-
November 2nd, 2011, 09:58 AM
-
November 2nd, 2011, 09:28 AM
this is my array when pulling the data from data base
SNEX_ARRAY$(EXE_BR) = QU_ARRAY$(QU_BR)
SNEX_ARRAY$(EXE_PTGLNO) = QU_ARRAY$(QU_PTGLNO)
SNEX_ARRAY$(EXE_SPACES_1) = " "
...
|
Click Here to Expand Forum to Full Width
|