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

2013-10-03 Thread ashish koul
check attached file see if it helps On Thu, Oct 3, 2013 at 8:20 PM, wrote: > > > On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote: >> >> With ActiveSheet.QueryTables.Add(Co**nnection:= _ >> "URL;https://secure.**fundsupermart.com/main/** >> fundinfo/dailyPricesHisto

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

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote: > > With ActiveSheet.QueryTables.Add(Connection:= _ > > "URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=FI3039"; > , Destination:=Range( _ > "$A$1")) > .FieldNames = True

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

2013-10-03 Thread asdhhc
On Thursday, October 3, 2013 4:50:23 PM UTC+8, asd...@gmail.com wrote: > > With ActiveSheet.QueryTables.Add(Connection:= _ > > "URL;https://secure.fundsupermart.com/main/fundinfo/dailyPricesHistory.tpl?id=FI3039"; > , Destination:=Range( _ > "$A$1")) > .FieldNames = True