Pages

Sunday 3 November 2013

Data Copy from Web Page

Are you sick of copying the same data again and again from web page and hate it like anything? 

Do you copy your equity share report from web page in every 1 hour and still don’t get all figures in one go?

Following information might help you… ...

Let’s see how we can make it simple -
-Open internet explorer and surf your equity page
-Copy the web address and open excel sheet
-Go to Data tab and Click on From Web button
-Paste the copied address in the Address Comb box and Click on Go
-Wait till the time box shows you the web Page inside the Web query box
-Then click on Import Button and your half work is done

Now you don’t need to visit the web page every time, you can open the same excel file and get your data readily available in excel.

Please Note :
While opening the excel file, Microsoft Excel will throw a Security Warning saying that data connection have been disabled, you need to click on Options and then Enable this content every time.
Now you can refresh your data in Data Tab.