Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-04 Thread asdhhc
On Thursday, October 3, 2013 11:01:36 PM UTC+8, ashish wrote: > > check the attached file see if it helps > > working. Thank you. > Plse teach me how to make 'Run macro' icon as per your attached query.xlm regard Ray Ho > > On Thu, Oct 3, 2013 at 8:24 PM, > wrote: > >> >> >> On Thur

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 11:01:36 PM UTC+8, ashish wrote: > > check the attached file see if it helps > > still not working > > On Thu, Oct 3, 2013 at 8:24 PM, > wrote: > >> >> >> On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote: >>> >>> try something like this >>> >>>"URL;ht

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread ashish koul
check the attached file see if it helps On Thu, Oct 3, 2013 at 8:24 PM, wrote: > > > On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote: >> >> try something like this >> >>"URL;https://secure.**fundsupermart.com/main/** >> fundinfo/dailyPricesHistory.**tpl?id=

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote: > > try something like this > >"URL; > https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id="; > & Sheet1.Range("H1").Value, Destination:=Range( > "A1") > *not working* > > On Thu, Oct 3, 2013 at 2:20

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 10:10:03 PM UTC+8, ashish wrote: > > try something like this > >"URL; > https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id="; > & Sheet1.Range("H1").Value, Destination:=Range( > "A1") > not working > > On Thu, Oct 3, 2013 at 2:20 PM

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread ashish koul
try something like this "URL; https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id="; & Sheet1.Range("H1").Value, Destination:=Range( "A1") On Thu, Oct 3, 2013 at 2:20 PM, wrote: > original link : > https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistor

$$Excel-Macros$$ export table to Excel from a link

2013-10-03 Thread asdhhc
original link : https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id= FI3039 With ActiveSheet.QueryTables.Add(Connection:= _ "URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=Sheet1.Range("H1").Value", Destination:=Range( "A1"))

$$Excel-Macros$$ export table to Excel from a link

2013-10-02 Thread asdhhc
link is : https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=DBSAUD -- 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 co