View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Understanding and comparing stock market figures


Excel version?
At the table, Click your mousethen right click

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
When I go to the website and right click on the desired table, I do
not get the option "Import to excel" The options which I get are Back,
Forward, Reload, Stop, Bookmark this page, Save page as, Send link,
View background image, Select all, View page source, View page info.

Moreover, you told me how to do it (incorporate into a loop), I don't
know how to do this since I am not much into excel programming.

Thanks
Sandy

On Jan 22, 7:32 pm, "Don Guillett" wrote:
This is the sort of thing I do for clients often. The basic way I do this
is
to goto the web siteright click on the desired tableimport to excel.
Once
importeddataimport external dataedit queryetc. Then record a macro
doing
thatincoporate into a loop using your variable
numberhttp://money.rediff.com/money/jsp/co_results_hy.jsp?companyCode=17040007
"URL;http://money.rediff.com/money/jsp/current_stat.jsp?companyCode=" &
mycodenum

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
...@gmail. com wrote in message