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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
msquery to as400 using a cell as criteria (From FAQ)
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...- scotsql
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Finding a Cell refrence...
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..- scotsql
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Combining 2 queries
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... -
Saving Excel to 123
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- scotsql
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
