Hi,
I am new to writing macros to MS office application. I have the data in Excel sheet, which needs to be exported to a web page and results from webpage should be imported to excel sheet. Can some one help me how to write a macro.
Here is the details
In my excel sheet 1, Col - A and B has the data (A- Origin and B- destination codes). I want these code to be applied in following website www.amadeus.net under Time table section category "one way", Cell A2 data should go under "From city or Airport" and Cell B2 should go under "To City or airport" and Cell A1 and B1should go under "depature date - A1 month (Jul08) and B1 should go under date" and the result should be exported to C1, D1,...etc. Similarly all data in rage A2:A65000 and B2:B65000 should be searched for results. Cell A1 and B1 remains contant per search. There will be image in result should go as text in excel.
Appreciate if some one can guide me in writing this macro.
Regards
Sriram
I am new to writing macros to MS office application. I have the data in Excel sheet, which needs to be exported to a web page and results from webpage should be imported to excel sheet. Can some one help me how to write a macro.
Here is the details
In my excel sheet 1, Col - A and B has the data (A- Origin and B- destination codes). I want these code to be applied in following website www.amadeus.net under Time table section category "one way", Cell A2 data should go under "From city or Airport" and Cell B2 should go under "To City or airport" and Cell A1 and B1should go under "depature date - A1 month (Jul08) and B1 should go under date" and the result should be exported to C1, D1,...etc. Similarly all data in rage A2:A65000 and B2:B65000 should be searched for results. Cell A1 and B1 remains contant per search. There will be image in result should go as text in excel.
Appreciate if some one can guide me in writing this macro.
Regards
Sriram
