Recent content by nelsonwang

I have one suggestion - instead of write down all the variety of the conditions in 10 columns (seems each column uses different CF), add 10 more columns (say AA, AB, AC, etc.). Manually assign values of 1,2, or 3 to column AA if the first column is green, yellow or red. Repeat it for all...

Hi SirJB7, thank you very much for your advice and prompt response. Reading your posts and realized it is really a great idea - I never thought about copy the source code and find the values that way... the example you provided definately showed me a path to a new direction. Thanks again. At...

Hello, my excel file has a list of zip codes, and I am trying to look up these zip codes on FedEx website to determine the shipping zones, and then bring the results back to the excel file. I wrote following codes, using InternetExplorer.Application to connect to the FedEx webiste. I am able...