Recent content by scotsql

thanks again. with this Dim sSQL As String sSQL = "SELECT DATA.LHENDT, DATA.MQUSER, DATA.`00003`, DATA.ITEGNG " sSQL = sSQL & "FROM DATA DATA " sSQL = sSQL & "WHERE (DATA.LHENDT = '" & Sheets("Sheet1").Range("f1") & "') " i am getting a general odbc error?? so sorry to be a...

that has worked great!! now i want to try so that DATA.LHENDT is equal to cell F1 and all my trying just keeps on getting errors. any ideas? thanks again for everyones help guys.

thankyou so much for your posts. skip im still having trouble with this . what should the whole code look like? i really appreciate your help.

sorry this is not querying as400 this is querying excel. sorry again my head is not screwed on right today.

Hi there, I am trying to use VBA to query and as400 system using a cell as a criteria. i got the following from an FAQ here: Sub query() ' ' query Macro ' Macro recorded 01/04/2005 by Blount ' ' With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=Excel...

Hi all, I want a formula which will tell me the cell reference in a range if it equals another cell. But this just gives me FALSE =IF(A1:A106=K1,CELL("address",A1:A106)) i hope i have explained this well enough. thanks for any help..

you could create a sheet for each hotel then embed a query into that sheet specifying which hotel to pick up....

Hi all, i hope i am entering this in the correct forum. I have a query which uses odbc to connect to an as400 system. I need to specify to only pull records which have certain usernames (a list of about 200) the only way i have been able to do this is to specify each user in the sql. is it...

Hi all, I have found it possible to use vba to save an excel file as lotus wk4 file. but is it possible to save as lotus 123? any help would be greatly appreciated. Bob