Excel : additionnez des factures sans les ouvrir

Vous tes ici : Accueil > Astuces

Publi le : 15/06/2011 vers 14h
Mise jour le : 19/05/2011 vers 23h
Catgories :
  • Office

Auteur(s) :
Gilles SALOMON (Membre depuis le 08/10/2008)
Socit :
Fonction :
Contactez cet auteur - Affichez les ressources de cet auteur

Dans un dossier, un certain nombre de classeurs Excel sont regroupés, chacun correspondant à une facture. Ces factures ont toutes la même structure : le total à payer se trouve toujours dans la cellule H10. Comment totaliser automatiquement les montants de toutes les factures du dossier, sachant qu'il en arrive régulièrement de nouvelles ?

Pour résoudre votre problème, vous allez créer une macro qui examinera tous les classeurs du dossier (C:\Factures dans notre exemple) et additionnera les valeurs de la cellule H10 de chacun.

Pour cela, créez un classeur Excel dans un autre dossier puis tapez Alt + F11 pour ouvrir l'éditeur VBA. Déroulez le menu Insertion, Module et saisissez le listing ci-contre.

Sub Total_Factures()
Total = 0
Dim NomFichier As String
    NomFichier = Dir("C:\Factures\*.XLS")
    Do Until NomFichier = ""
        Workbooks.Open Filename:="C:\Factures\" & NomFichier
        '-- Instructions effectuées pour chaque fichier ------
        Total = Total + [H10] : ActiveWorkbook.Close
        NomFichier = Dir
    Loop
    MsgBox "Total des factures " & Total
End Sub

Revenez à Excel et tapez Alt + F8, sélectionnez Total_Factures et cliquez sur Exécuter. Le total s'affiche dans une boîte de dialogue. Notez que, en remplaçant Total = Total + [H10] par les instructions de votre choix, vous pouvez appliquer n'importe quel traitement à un ensemble de classeurs.  (Source 01 net)

Votre commentaire:

Votre pseudo :

Votre commentaire :

Saisir les caractres ci-contre dans le champ suivant :
 Rafraichir

PseudoCommentaire
gordon
01/02/2017 08:29:23
sumV5B http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
gordon
31/01/2017 16:44:16
kB2Mg6 http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
matt
30/01/2017 07:37:14
pQSySn http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
chaba
30/01/2017 06:22:54
29obtj http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
chaba
29/01/2017 14:00:46
ZnlwVB http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
matt
29/01/2017 13:54:02
32GEca http://www.y7YwKx7Pm6OnyJvolbcwrWdoEnRF29pb.com
Barnypok
08/01/2017 15:15:54
zHfgCS http://www.FyLitCl7Pf7ojQdDUOLQOuaxTXbj5iNG.com
Barnypok
29/12/2016 13:04:23
4FmIQA http://www.FyLitCl7Pf7ojQdDUOLQOuaxTXbj5iNG.com
Barnypok
29/12/2016 10:10:09
eI9snm http://www.FyLitCl7Pf7ojQdDUOLQOuaxTXbj5iNG.com
Barnypok
29/12/2016 00:47:11
U8izIi http://www.FyLitCl7Pf7ojQdDUOLQOuaxTXbj5iNG.com
Edmond
15/10/2016 10:47:42
I'm training to be an engineer elavil dosage for cats BOJ Governor Haruhiko Kuroda said on Thursday while overseas economies were weaker than expected that would be offset by robust domestic consumer spending and a pick-up in capital expenditure, and so he remained confident of meeting a target of lifting inflation to 2 percent in roughly two years. krem aldara na recepte The printers would serve as a flying factory of infinite designs, creating objects by extruding layer upon layer of plastic from long strands coiled around large spools. Doctors use them to make replacement joints and artists use them to build exquisite jewelry. what is albuterol sulfate inhalation solution used for David Penchyna, leader of the Senate's energy committee anda member of Pena Nieto's Institutional Revolutionary Party(PRI), said the proposal will seek to change the constitution toallow either concessions or risk-sharing contracts. nexium 20 mg for sale We're taking the increased margin that we're getting and reallocating to invest in future growth, Kennedy said Thursday. But everything says we're firing on all cylinders. We're still in the earliest days. We have to invest to make the most of a huge opportunity. escitalopram tablets ip 20 mg Witnesses said the terrorists tossed grenades and sprayed mall-goers with AK-47 bullets after telling Muslims to leave what became a death trap. Al Shabab, a notorious Somalian rebel group with ties to Al Qaeda, claimed responsibility for the massacre. l arginine dosage for hair loss If you're negotiating around buying somebody's house, you don't get to say, 'Well, let's talk about the price I'm going to pay,' said Obama. 'And if you don't give me the price, then I'm going to burn down your house.' That's not how negotiations work. acheter moduretic The United States offers plaintiffs the prospect of largerrecoveries than Canada, but they would need to prove a U.S.venue would be the most convenient and appropriate. Lawyers saidthat could be tough when the damages to the rural Quebec townand its residents would likely be at the heart of any suit. toprol xl 50 mg half life I was shocked by the rulings, the head of the main employers' union Pierre Gattaz told BFM TV on Friday. The law must change so that it stops wreaking havoc. It's unbearable: clients want to consume more and staff want to work more and they can't. It's crazy. finasteride for female pattern hair loss And yet: All they have to do is look across the diamond at where their broken-down third baseman was, until he couldn’t even make it through a seven-week season. Look at the deal they gave him when they didn’t have to. Look at what they’re getting out of it on the back end.
Madelyn
15/10/2016 10:47:40
On another call shatavari ghee Hamidi took the binoculars and, keeping as low a profile as possible, glassed the valley floor. One of the men had laid his long barreled rifle on the ground, the muzzle raised above the dirt by a fairly long tripod just forward of the receiver, and was going through the dead Russian’s pockets. price rogaine men The ASA said the advert's target audience would understandthat the plane's highly-customisable nature meant any efficiencyclaims based on fuel burn per seat would be subject toconsiderable variability depending on a customer's exactspecifications. solu medrol extravasation treatment Supermarket operator Aeon Co Ltd and conveniencestore owner Seven and I Holdings Co Ltd reported recordhigh net profits in the March-May quarter, but growth waslargely due to strong sales of their own-label goods which areoften cheaper than branded items but carry larger margins. levothyroxine levothroid same A CFP Board spokesman said a steady flow of advisers haveupdated their profiles to conform with the compensationrequirements since receiving the email. He did not have specificnumbers on how many of the more than 8,000 planners whoself-described as fee-only have made the changes. paracetamol 500 rezeptfrei There's also an outside chance the Giants would keep only two quarterbacks with rookie Ryan Nassib as the backup, but Gilbride said that would happen only if they think Nassib is ready to play immediately. He indicated it was more likely they'd keep three. voltaren hinta Prosecutors on Friday charged the boy's 16-year-old half brother with murder. The teen is due in juvenile court on Monday, and prosecutors have requested a hearing to determine if he should be tried as an adult. mifepristone misoprostol dosage india Better reports on business activity for the United Statesand Europe on Wednesday had encouraged investors to reduceholdings of safe U.S. and German government debt, and supportedshare prices - despite further evidence of a slowdown in China. motilium sans ordonnance Although today's result can in no way compensate the family and friends of Reece, Holly, Ella and Jordan who needlessly lost their lives in this terrible crime, we can only hope the justice that these verdicts have delivered brings them some measure of comfort. Our thoughts are with them.
Refugio
15/10/2016 10:47:37
What do you want to do when you've finished? paroxetine hcl 12.5 mg Italy has major economic interests in Kazakhstan, including energy group Eni's stake in the giant Kashagan oil field. The case has also highlighted the close relations between Berlusconi's former government, in which Alfano served as justice minister, and Kazakh President Nursultan Nazarbayev, who has ruled the oil-rich state for 17 years. ky jelly bulk Many index providers have fast entry rules in place thatdetermine when a new IPO stock can be added to an index,typically five or six days. Even once an index adds a stock,some ETFs, such as First Trust, wait until their fund'squarterly rebalancing period, which can sometimes be monthslater. generic nexium esomeprazole Alison was appointed Editor of the Daily Post in March 2012, becoming the first female editor of the title in the process. Alison had held varied high profile roles in newsroom across the UK, most notably as Editor of the Wales on Sunday and WalesOnline. A pioneer of the newspaper industry’s transition to digital publishing, Alison also holds an MA in Journalism Leadership allitm orlistat 60 mg - 150 capsules Nigel Farage MEP, the leader of Ukip, accused Mr Barroso of creating a myth. Those of us who believe in national democracy do not want to take us back to the Western Front or 1914. Those of us who believe in national democracy will say to you that it is a healthy assertion of identity. But it also shows a deeper misunderstanding of why the problems of Europe were caused in the past. It is democratic nation states in Europe that are stable and will not go to war with each other. do you need prescription rogaine australia Zimmerman's defense team have complained repeatedly that race was wrongly injected into the case and that Zimmerman acted in self-defense, accusing civil rights leaders of inflaming racial passions with their calls for a federal investigation of Zimmerman on civil rights grounds. metoprolol succ er 25 mg uses Asked about Turkey's decision, a NATO official said it wasup to each nation to decide what military capabilities theyacquire but that it was also the alliance's understanding theTurkish decision was not final. achat tegretol He's a quarterback, he's a very important player to our team, Idzik said on why the team chose to use the spot on Sanchez, who is a backup at the moment. That designation is tailor-made for somebody like him.
Desmond
15/10/2016 10:47:34
I support Manchester United 600 mg ibuprofen every 4 hours In April, Tepco warned it may run out of space to store thewater and asked for approval to channel what it has describedgroundwater with low levels of radiation around the plant and tothe sea through a bypass. Local fishermen oppose the proposal. interaccion ciprofloxacino alcohol He testified in court that his daughter had endured years of domestic violence at the hands of her partner. And yet the prosecution - which sought a 50-year jail term - relied heavily on this man's allegation that she had intentionally killed the foetus. endep 50 mg amitriptyline While state laws give parents a great deal of freedom when it comes to choosing medical treatment for their children, that's not always true when the decision could be a matter of life or death. Courts most often will draw the line when doctors think the child's life is in danger and there's a good chance that the treatments being suggested will work, according to several medical ethicists. isotretinoin actavis blogg Hefner admitted Sunday that he had been struggling with elbow pain and soreness recently. It seems be reflected in his dramatic slide after the All-Star break. In the eight starts before the break, Hefner went 3-1 with 1.76 ERA. In his last five starts, the 27-year old is 0-2 with a 9.13 ERA.  cleocin ovules generic Despite other priorities, namely Syria, Obama spent 45 minutes with Rousseff at a September 5 summit in Russia to try to ease her concerns. He also made a last-minute plea by phone for 20 minutes on Monday. ibuprofen or tylenol for swelling This – the issue of language – highlights another challenge facing the next Fed chairman, and one which could help to swing things in Summers’ favour. Often, the FOMC minutes would suggest that tapering was a long way off, but Bernanke would all but contradict that view shortly after at the press conference that follows.
Damian
15/10/2016 10:47:29
I wanted to live abroad precio ivermectina inyectable “We had a lot talk to about, he and I,” she says. “And I said to him: 'I believe that you and I need to remember who we were when we were 16 and 17 years old. We need to remember that we were really good friends before we ever had a date. etoricoxib arcoxia mims 2011 - RIM launches PlayBook, which is panned for lacking coreBlackBerry functions such as email and organizer capability. Itlater books a writedown on unsold PlayBook inventory. Companyslashes financial forecasts, the first of many revisions, whichit then misses. Says will slash more than 10 percent of itsworkforce. Resists investor pressure for co-CEOs Lazaridis andBalsillie to step down. Offers to manage rival devices includingApple's iPhone and iPad. Delays its QNX-based BlackBerry 10phones until late 2012.2012 - Lazaridis and Balsillie step down as co-chief executivesand chairmen. Thorsten Heins appointed CEO and Barbara Stymiestnamed chair of the board. Heins promises overhaul, says RIM willno longer issue financial forecasts. RIM hires bankers to assistwith strategic review, delays BlackBerry 10 again, until early2013. Shares hit lowest level in nearly a decade. para que sirve el medicamento solumedrol RA is a chronic and often painful disease affecting the joints, causing them to become inflamed. An inflamed joint looks swollen and red and appears warm to touch. This inflammation can lead to permanent damage in the joints if the disease is not treated. Around 40,000 people in Ireland are affected. force factor test x180 testosterone booster reviews Politicians of both parties figured out it’s always easy to give a benefit today that someone else funds decades into the future. Face it, politicians have screwed over our young people to get elected for the sole purpose of getting elected. pilexil shampoo precio mexico Then our son got sick with a stomach virus, and I caught it. Chris said, 'No, babe, you're a little sicker than Sebastian. You need to go and get that checked out,' and I said, 'Okay.' So I went, and they tested me and said, 'Oh honey, you're not dehydrated. You're two months pregnant.' creme fucidine sur ordonnance Many Alaskans are skeptical about the climate link. Permafrost has been thawing since the last Ice Age, says Jeff Curley, an engineer for the Alaska Department of Transportation, saying its amount depends on naturally-occurring variability. He notes the state's temperatures have fluctuated every 30 or so years. atorvastatin 30 mg preis But just because a storm is not technically classified major with 111 mph winds or more, doesn't mean it can't do lots of damage. Sandy is evidence of that, Bell said. The storm caused hundreds of miles of flooding, killing 147 people and causing $50 billion in damage. budget kitchen renovations melbourne We are rejecting the results because they are fraudulent, Tsvangirai said. We will go back to our people. Our people are the ones hurting. Our people are disciplined. We don't want a violent resolution to this crisis. minoxidil 5 prescrizione medica Will there still be an Ashes in a generation’s time? Will it have to be replaced by a Twenty20 extravaganza? Or just settled the old-fashioned way, out on the cobbles of Twitter? Hughes will walk off now, Michael Clarke next; why is he hiding himself at five? Shouldn’t he be coming out to avert a crisis rather than into the teeth of it?
Rodger
15/10/2016 10:47:23
Have you got any experience? safe dosage of metformin for weight loss In one shot, Danes and Lewis are sprawled out on a bed together, and in another Danes stares into a mirror as Lewis sits nearby, a recreation of the famed interrogation scene from the show's second season. ciprofloxacin ophthalmic solution usp 0.3 for dogs Richard and Alfie Elgar can be heard sharing their emotional story on the radio advert calling on the people of Dorset to support the Great British Bagathon to stock the charity’s many high street shops. flagyl side effects urine So far, Kyprolis is cleared for use in patients in the U.S. who have failed at least two previous multiple myeloma therapies. But the drug is in testing that is aimed to secure approval in Europe, and for use earlier in multiple myeloma treatment. cytotec precio 2013 mexico The New York Red Bulls and Brazilian defender Digão agreed to part ways on Friday, ending one of the team's most ill-fated acquisitions of recent times. Digão, 27, joined the Red Bulls on a one-year $90,000 contract last year in a move that was widely expected to facilitate a deal for his brother, the Brazilian star Kaka. Despite playing just one minute in a meaningful match, Digão was re-signed on a $200,000 contract for this season, but never played. The move comes weeks after Red Bulls executive Andy Roxburgh said a deal for Kaka was unlikely. para que es hydroxyzine hcl 50 mg The British firm has long been touted as a takeover targetin an industry dominated by larger rivals and some analysts hadspeculated Schneider's interest could prompt rival bids fromfirms like Emerson and General Electric. sildenafil citrate billig Last month, the government announced a new long-term strategy for the control of bovine TB in England, pulling together various policies, involving the government, the farming industry, vets and scientists. lek clindamycin-mip 600 cena For example, numerous studies now associate lack of sleep with an expanded waistline. Other studies have found that exposure to certain insecticides and plastics disrupt gut bacteria, which may stimulate appetite, slow digestion and accelerate fat storage. And some studies propose a link between the lifestyle habits of great grandparents and their great grandchildren's weight status.
Leonard
15/10/2016 10:47:20
I stay at home and look after the children cost of ibuprofen in nigerian The musician has lent her vocals to the track about Shaker Aamer. Shaker has long been cleared for release by the US and has never been charged with a crime in the country, according to legal action charity Reprieve. He has been held at the Cuban detention camp since 2002. precio zanaflex Are parking ticket fines tax deductible? If the big time crooks on Wall Street can get tax deductions for their very real criminal case fines, why not tax deductions for the little guys for their small infractions? penegra 50 medicine Colburn's testimony before the Senate Commerce Committee last week was filmed by a Discovery crew for the season that begins in April. The effects of the furlough on the fishery also are being documented, but Colburn hopes it will turn out to be no more than a blip in the show, if anything. pulmicort prix tunisie The steel maker estimated a wider-than-expected loss for thethird quarter as production was hit by a mechanical failure atits Ohio facility, sending its shares down 7 percent inafter-market trading. The steelmaker said it expects to incur aloss of 22 cents to 27 cents per share. Analysts were expectinga loss of 11 cents per share, according to Thomson ReutersI/B/E/S. cipralex magyaroldalak Fang Li, vice director of the city's Environmental Protection Bureau, acknowledged that the measures would not prevent smog wafting into Beijng from neighbouring provinces such as Heibei. As much as 60 per cent of the capital's air pollution is said to come from outside sources. how often to use permethrin cream 5 She described the new Child and Family Agency as a major milestone in this country, however she insisted that if cuts are imposed on it, ‘it will be disastrous even before it has gotten off the ground'. amoxicillin capsules open Now, the crisis in Syria and the destabilisation of the region goes to the heart of broader challenges that the international community must now confront. How should we respond to conflicts in the Middle East and North Africa, conflicts between countries but also conflicts within them? How do we address the choice of standing callously by while children are subjected to nerve gas or embroiling ourselves in someone else's civil war? What's the role of force in resolving disputes that threaten the stability of the region and undermine all basic standards of civilised conduct? And what's the role of the United Nations and international law in meeting cries for justice?
Irea
15/10/2016 10:47:18
What do you want to do when you've finished? duphaston tanpa resep dokter Mediobanca, which has for decades played a pivotal role inhelping to forge Italian capitalism, announced in June a radicalchange of strategy that will see it curb or sell stakes in someof Italy's biggest corporate names to focus squarely on banking. dapoxetine generic india Emergency officials confirmed a 43-year-old man died when his water bomber fixed-wing aircraft crashed in the Budawang National Park, 270 km (170 miles) southwest of Sydney, a wilderness area popular with hikers and campers. ist xtrasize gut The letters appealed for help from recipients of Qamar's donations, such as Pennsylvania Senator Robert Casey, whose office said it referred the doctor to his own representative, and Indiana Representative Andre Carson, whose office said it initially inquired into the case before being told that Democratic Florida Senator Bill Nelson was involved. amitriptyline withdrawal symptoms nausea It has already announced new guidelines for potentialreverse mortgage borrowers, including lower limits on the amountseniors can withdraw, higher mortgage insurance fees and toughervetting of applicants. Those changes, however, do not go intoeffect until Tuesday. elavil for migraine treatment JERUSALEM (AP) — After a nail-biting race that went on long into the night, the secular mayor of Jerusalem won a second term Wednesday in a hard-fought campaign that saw him fend off a challenger backed by two of Israel's biggest kingmakers in an election that was the centerpiece of nationwide municipal voting. indian karela masala Once the world's largest insurer by market value, AIG was bailed out on September 16, 2008, as losses were skyrocketing from risky bets on mortgage debt through credit default swaps. The government initially took a 79.9 percent stake in the New York-based insurer. nexium price drop The 2008 deadlock was broken by a unity government brokered by South Africa but Mugabe ruled out another compromise outcome with a man with whom he has struck up a cordial working relationship that includes tea and cake on Monday afternoons.
Dallas
15/10/2016 10:47:15
Through friends precio bactroban 20 mg/g pomada The Bank expects all major British lenders to meet a new so-called “leverage ratio” of 3pc by June 2014. This means that banks must hold shareholder equity equal to 3pc of the total value of their assets. plavix desconto laboratorio “Being a fly ball pitcher, it makes it more difficult, there’s no doubt about it,” Girardi said of Hughes’ home-road splits. “He has had a hard time keeping the ball down in the zone, and teams are putting long at-bats on him and that has gotten him into trouble.” adapalene cream 0.1 ingredients Glaxo has been accused of bribing medical personnel in order to boost sales of its drugs in China. The company initially denied the allegations but the company is now holding its hands up and admitting to violations. dulcolax bisacodyl 5mg dosage Without Indian Point, it’s quite possible a heat wave would deliver rolling blackouts throughout the city. Not only would that mean millions of sweating residents, it would endanger the health of the sick and the elderly. allopurinol cost Mr Starmer said that, earlier this month, the file in this particular case arrived at the CPS and he would not fall into the trap of commenting on the case at this critical stage. dapoxetine online espao-a Earlier this month, a federal judge in Virginia upheld federal and state pollution limits worked out by the EPA, six states and Washington, D.C., to improve the health of the Chesapeake Bay by more tightly regulating wastewater treatment, construction along waterways and agricultural runoff. The American Farm Bureau, one of 44 agricultural groups that asked to join EPA as plaintiffs in the Louisiana lawsuit, had challenged the regulations.
Darrel
15/10/2016 10:47:12
Could you transfer $1000 from my current account to my deposit account? paroxetine hcl 40 mg prices The city has been working with residents and businesses to make sure everything runs smoothly. People living in the neighborhoods nearest Francis Field were given parking passes so they can get in and out and prevent others from parking on the street. esomeprazole magnesium nexium tablets This Christmas we're doing Chicago and we're back on track. Clearly the public want sexy and new but familiar titles. Not old titles. If I did Oklahoma! we'd be empty. If they don't come this year, we will be in trouble. febrex 250 TCS has a history of growth, said Uralsib analyst NataliaBerezina. It is slightly different to those already on themarket - universal banks which have a large share of corporatebusiness, and, of course, with a lower rate of growth. taking methotrexate with ibuprofen They met for one hour where the prosecutor explained to the ambassador the case and the evidence available, Abdelatty said. He also emphasized the importance of respecting Egypt's sovereign judicial process and avoiding foreign interference. doxycycline hyclate 100mg cap coupon Many of these plants that have overcapacity problems haveactually idled their production line for a while, said RaymondYeung, an economist with ANZ Banking Group. So the actualimpact of the cut on the rebalancing of supply will be prettymild. is metronidazole 500mg used for std NEW YORK - The S&P 500 and Dow snapped five-day losing streaks on Thursday on positive job market data but gains were limited as investors worried if Washington lawmakers would pass bills to avoid a government shutdown and possible U.S. debt default on time. permethrin cream used for psoriasis She said the agency opposes donations from gay men who test negative because the virus is difficult to detect in its early stages. The policy is “currently under evaluation,” the spokeswoman said, and the FDA may “consider new approaches.” ibuprofeno 600 preo Though his family initially heard that “Oki” was dead, he survived damage to his spleen, pancreas and diaphragm. He spent 15 days at Kings County Hospital — four of them in a medically induced coma. elimite for pubic lice But violence began rising a few months after President Obama ordered all U.S. troops out of Iraq by December 2011. Shiite and Sunni Muslims have clashed over government policies, and the civil war in neighboring Syria has pitted Sunnis against Shiites as well.
Nos partenaires : www.bestof-microsoft.com | www.exchangedump.com | www.exchangedump.com | www.formation-exchange.com | www.formation-management-dif.com | www.formation-mcpd.com | www.formation-pmp.com | www.formation-seven.com | www.formation-windows-7.com | www.formation-windows7.com | www.formation-windows-seven.com | www.certification-mcpd.com | www.certification-windows-7.com | www.consulting-exchange.com | www.e-managementinstitute.org | www.certification-mcitp.com | www.formation-mcsa.com | www.bestof-exchange.com | www.exchange-consulting.com | www.bestof-voip.com | www.formation-cisco.com www.formation-mcitp.com.com | www.laboratoire-exchange.com | www.messagerie-consultant.com | www.bestof-windows.com | www.bestof-sharepoint.com | www.messagerie-consultants.com | www.formation-mcts.com | www.consultant-messagerie.com