Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-30 Thread Ashish Kumar
Yes, Vaibhav Joshi is the Best. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-30 Thread Vaibhav Joshi
aibhav Joshi > *Sender: * excel-macros@googlegroups.com > *Date: *Tue, 30 Dec 2014 17:28:28 +0530 > *To: *excel-macros@googlegroups.com > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Data Fetch From Particular URL > > Its difficult to ans witho

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-30 Thread meetgoni
Subject: Re: $$Excel-Macros$$ Data Fetch From Particular URL Its difficult to ans without seeing actual URL, you can try this... Sub Macro1() Dim url As String 'enter your url below in quotes url = "https://?="; Application.ScreenUpdating = False For i = 2 To 100 ' c

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-30 Thread Vaibhav Joshi
Its difficult to ans without seeing actual URL, you can try this... Sub Macro1() Dim url As String 'enter your url below in quotes url = "https://?="; Application.ScreenUpdating = False For i = 2 To 100 ' change start date and end date With ActiveSheet.QueryTables.Add(Connection:=

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-30 Thread Vaibhav Joshi
Its difficult to ans without seeing actual URL, you can try this... Sub Macro1() Dim url As String 'enter your url below in quotes url = "https://?=+"; Application.ScreenUpdating = False For i = 2 To 100 ' change start date and end date With ActiveSheet.QueryTables.Add(Connection:=

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-30 Thread Rajeev Ranjan
Data come from company intranet site based the given value(Excel columns Value). eg: website address:- https://?="*excel columns Value"* On Tue, Dec 30, 2014 at 3:30 PM, Vaibhav Joshi wrote: > Let us know site name & what part of data you want to download.. > > + > *I did n

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-30 Thread Vaibhav Joshi
Let us know site name & what part of data you want to download.. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 30, 2014 at 3:26 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: > PLease if possible, share the code. > > On Sun, Dec 28, 2014 at 6:54 PM, Vaibha

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-30 Thread Rajeev Ranjan
PLease if possible, share the code. On Sun, Dec 28, 2014 at 6:54 PM, Vaibhav Joshi wrote: > check this...http://www.wiseowl.co.uk/blog/s393/scraping-websites-vba.htm > > + > *I did not do this for you. God is here working through me for you.* > > On Sun, Dec 28, 2014 at 12:43 PM, Rajeev Ranj

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-28 Thread Vaibhav Joshi
check this...http://www.wiseowl.co.uk/blog/s393/scraping-websites-vba.htm + *I did not do this for you. God is here working through me for you.* On Sun, Dec 28, 2014 at 12:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: >HI, > > please guide, How to get the data from Web

$$Excel-Macros$$ Data Fetch From Particular URL

2014-12-27 Thread Rajeev Ranjan
HI, please guide, How to get the data from Website from excel cell value. eg:- https://address?=excel cell value O/p:- data saved in excel workbook. SI Number 01140541537_dsl01143045624_dsl114242503501143685985_dsl01173714324_dsl 01145057810_dsl01160490431_dsl01145510368_ds