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, excel data web, 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 macro, macro vba, excel macro vba, data cleansing, create excel worksheet, cleansing, c1, data manipulation excel vba, net excel import, net vba, vba extract cell, range macro excel

About the Employer:
( 160 reviews ) Cairo, Egypt

Projektin tunnus: #4253811

2 freelanceria on tarjonnut keskimäärin 240 $ tähän työhön

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