I dont have a programming background. In my company we use .net based internal application for general ledgers and accounting entries. The data resides in sql, but it is not normalized. I have generate an xml based report from application web interface. it is called restful API and its URL is like this:

softwarename.companyname.net/restservice/softwareRestService.svc/xml/TransactionDetail/05‐01‐2012/05-29-2012

I have to save the xml on desktop and import it in xml and then import in access to create customized view. the date format is in text and I cant convert it into date format.
here is a sample of the xml file:

<TransactionDetailReport xmlns="http://schemas.datacontract.org/2004/07/Abacus.DomainServices.Implementation.Contracts" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<TotalCredits>148036303066.58033969465644</TotalCredits>
<TotalDebits>148036303066.60033969465648</TotalDebits>
<TotalTransactionsUSD>0.028749711</TotalTransactionsUSD>
- <TransactionDetailEntries>
- <TransactionDetailWebServiceSnapshot>
<CreatedDate>2012-08-13T15:45:00</CreatedDate>
<CreatedUser>FO452900A</CreatedUser>
<Credit>131.44000000000000</Credit>
<CurrencyId>39</CurrencyId>
<CurrencyLongName>Peruvian Nuevo Sol</CurrencyLongName>
<CurrencyTotal>-131.44000000000000</CurrencyTotal>
<Debit>0.00000000000000</Debit>
<Description>ChargMay-Jun-Jul/MDD/Aug12</Description>
<GLAccount>10323</GLAccount>
<GLAccountDescription>FO Local Currency Banking 4</GLAccountDescription>
<JournalDate>2012-08-13T14:45:00</JournalDate>
<LOE i:nil="true" />
<ModifiedDate>2012-08-13T15:45:00</ModifiedDate>
<ModifiedUser>FO452900A</ModifiedUser>
<OfficeID>280</OfficeID>
<OfficeName>Peru Forestry-Madre de Dios</OfficeName>
<PINCode i:nil="true" />
<PINName i:nil="true" />
<ProjectCode>452900</ProjectCode>
<ProjectDesc>Peru Forestry (Sales Log)</ProjectDesc>
<ReferenceNumber>GJ-1-b1</ReferenceNumber>
<RegionCode>352</RegionCode>
<RegionName>South America</RegionName>
<SER>2.61000000000000</SER>
<UDFields />
<USDAmount>-50.360153256</USDAmount>
</TransactionDetailWebServiceSnapshot>

It is just for one project and there are hundred of projects and thousand of transactions for each projects in there for each month.

two questions:

1) Is there a way that I can call restful API through VBA automatically.

2) I want to create an aging account receivable by 30,60,90, and 120 days by project number, region name, pin number, by GL account.

I will really appreciate your help on this. I also want to create a Pivot Chart where I can compare results..