Visual Basic

I used Chr(). Thanks

Thank you SMC, Can you please tell me how to get the position of the particular cell. and can you also check my following incorrect code please. I'm trying to wait for the user to close the excel application after they done with whatever they have to do to the excel file. where am i getting wrong and how to fix it. Dim idProc As Long Dim hProc As Long idProc = VBA.Shell("Excel", vbMaximizedFocus) hProc = OpenProcess(PROCESS_ALL_ACCESS, False, idProc) If hProc Then Do While WaitForSingleObject(hProc, 100) = WAIT_TIMEOUT DoEvents Loop CloseHandle hProc End If Thank you.

Sorry! My bad. It works fine. ----- We are what we repeatedly do. Excellence, then, is not an act, but a habit.

Erm....haven't looked in any detail, but would guess the problem is caused by you declaring variables without specifying a type (Long int et). By default, in VB6 any typeless vars are VARIANTS - and your function needs longs....

I'd recommend the following: - create a local variable based on a Trim() of the txtQuantity.Text - check length first - next, check for a false on IsNumeric() - only then look for certain integer values HTH limit further bugs btw, which line are you getting the type mismatch from? Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter. my svg article

mcm wrote: Do Until .EOF .MoveFirst Call Save(iOrderNo, strCode, strDesc, iQuantity, iFullPrice) .MoveNext Loop This code: Moves to the first record; Saves the record; Moves to the next record; Goes back to the start of the loop; Tries to move to the first record; Throws an error because you have a forward-only recordset; Change the loop to: Do Until .Eof ' TODO: Get these values from the recordset! Call Save(iOrderNo, strCode, strDesc, iQuantity, iFullPrice) .MoveNext Loop "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Actually, the flexgrid in VB6 was not free. You could use it but it kept popping up messages asking you to buy it. I guess .net just tightened the rules and made it so that you have to buy it before you can use it.. :( Notorious SMC The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain Get your facts first, and then you can distort them as much as you please Mark Twain

Visual Studio.NET can use VSS also. You should use 6.0c (which is the version that came with VS.NET Enterprise) since, if I remember correctly, it had some file types changes that help it work with VS.NET. 6.0c should be in the MSDN disks...

Array.Copy won't work, since there isn't a direct cast from DataRowView to String. You'll need to copy the array manually: Joe = Array.CreateInstance(GetType(String), lookupRows.Length) Dim i As Integer For i = 0 To lookupRows.Length - 1 Joe.SetValue(lookupRows(i).ToString(), i) Next However, since DataRowView doesn't override the ToString function, you'll just get an array filled with the string "[System.Data.DataRowView]". The DataRowView class isn't serializable, so you would need to write your own function to convert it to a string. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Set RS = Conn.Execute(nSQL) I think the above statement is the problem .. you execute a statement that inserts data in a table and does not return a recordset .. try using : Conn.Execute(nSQL)