Peruttu

VBA Excel - import data from web into Microsoft Excel

looking to import data for a 12 month period. 100 rows of information per day.

pre recorded basic macro for the date of 16th February 2013 done. file to be supplied. succesfully pulls in data required.

but need to create a loop from user entered parameters in the main excel worksheet ( 4 or 5 ).

eg Excel cell a1 = start date 2012/01/01, b1 = end date 2013/02/16 , c1 = event code SR , d1 = destination range, e1 = other?

so as to extract data over a 12 month period say.

Only 1 error trap required ..... eg on a particular day there may not be a sr event. this date needs to be recorded.

Fixed price easily determined as extended project is a byproduct of already working macro for 1 day. data cleansing / manipulation not required inside current worksheet.

Taidot: .NET, Adobe LiveCycle Designer, Microsoft, Visual Basic, verkkosivujen suunnittelu

Näytä lisää: vba import data web, excel import web, import web data excel vba, excel data web, price for vba for excel, microsoft project import, loop net, vba error, microsoft vba, microsoft project price, microsoft macro, microsoft excel VBA, microsoft excel price, excel 2013 vba, end vba, vba excel, vba excel macro, project on vba, Macro vba, Excel Macro VBA, data cleansing, create excel worksheet, cleansing, c1, data manipulation excel vba

Tietoa työnantajasta:
( 160 arvostelua ) Cairo, Egypt

Projektin tunnus: #4253811

2 freelancers are bidding on average $240 for this job

mantislin

Hi sir, please check PM, thx Kimi.

250 $ USD 5 päivässä
(41 arvostelua)
5.8
cheapexcell

Please provide more details

230 $ USD 0 päivässä
(38 arvostelua)
4.5