Search results for query: *

ID NAME PHONE1 PHONE2 1 KEVIN 911 988 2 TOM 897 3 LISA 485 485 Above is my table, I would like to write a vba script to check if phone1 is blank then move phone2 value to phone1. Can anyone please help me? Thanks the end result should look like this ID NAME PHONE1 PHONE2 1 KEVIN 911...

yes, Could you please show me how this could be done? Thanks

i have two tables, table A contains old customer names, and table B contains new customer names. Each table has about 1000 rows. I want to write a query or vba macro to first look up in the table B, if a name is existed in old customer(table A) table then replace the customer name field to...

anyone got of a solution?

I tried to use the object like you suggested but it didn't have the method or prop. I will try the recording suggestion though. thanks Kevin

I am working on Excel vba to control Extra attachmate. i am trying to write codes for the program to click on tools menu, click on " capture incomming data " , enter the name into the diaglog box and click save. I used they sendkeys command but it doesn't work. anyone got any suggestions...

thanks alot

lets say i set system as Set system = CreateObject("EXTRA.System") how would i declare system so everytime i type system. it will give me a list of all of the methods or properties that that associated with system. i tried dim system as attachmate.extra and that did not work. thanks in...

thanks Calculus!

PHV, can you please explain how does this work and can i have more than 4 colums? perhaps, 40 colums??? thanks alot !

I need to use Distinct to return unique records by order number but I also need to return the rest of fields that are not part of the Distinct. For example: SELECT Num, Type, Customer FROM Order_Table Num Type Customer ------ ------ ------------ 1 YY 1001 ABC 1 AA 1001 ABC 2 SD 2001 FFF 3...

Thanks for the reply but my excel file is very big and hundreds of formulars. it would be a time consuming to edit each function. I was wondering if there is a vba macro or codes to search through each cell and change instead of using funtions in excel like you suggested. Thanks for the help!

I apology for not given enough infomation. The work that i am working on right now is through Attachmate Extra. After it executed the commands it will open a text file and because the text file is few pages long it will scroll across the screen. Out of all the pages there will be one page in the...

I just browse through the forums and found answer for 1 and 2 can anyone help me on part 3 thanks

i have a macro that pull up data from Oracle server. After i pulled onto Excel I have functions that do calculations based on that data. The problem is sometims it displays as div 0 is there any way i can write a vba code that search through every cell and if it's div 0 then change it to 0. As...

Say my current folder is c:\test\ anyone know how to write vba code that search and execute every files that that directory and its subdirectory. thanks kevin

Hi everyone, I just started learning to program in Extra and i have a few questions. 1. for example my code would be Sess0.SCREEN.WaitForString "Select Function" how can i write a statement to say like if there is a string called"select function" then sendkey"1" else sendkey"2" end if 2. how...