Hi,
I am pretty new to VBA and have a task which involves following steps:
step 1- Copy a ticker (string) from excel file (say cell A2)
Step 2- Open a particular url (Say GoogleFinance)
Step 3- Search the copied ticker (string) in the search box on the website (by clicking the search button)
Step 4- Download excel file in the result (by clicking excel icon against the name of the company)
Step 5- Automatically save the file in desired location and repeat the loop (search for next ticker in cell A2, A3,..)
I have tried few codes from various forums but haven't got the desired result or fully working codes. Pleasse help me on this and provide any code, materials,links anything that can help.
Thanks
I am pretty new to VBA and have a task which involves following steps:
step 1- Copy a ticker (string) from excel file (say cell A2)
Step 2- Open a particular url (Say GoogleFinance)
Step 3- Search the copied ticker (string) in the search box on the website (by clicking the search button)
Step 4- Download excel file in the result (by clicking excel icon against the name of the company)
Step 5- Automatically save the file in desired location and repeat the loop (search for next ticker in cell A2, A3,..)
I have tried few codes from various forums but haven't got the desired result or fully working codes. Pleasse help me on this and provide any code, materials,links anything that can help.
Thanks