The only methods I found posted were to use a crow bar or Jaws of life to open the hood...believe me when I say I felt like it after messing around for 3 hours trying to open the hood.
Finally I gave up and took it to the dealer.
They charged:1.0 hrs labor + $0 Parts + $4 Misc Shop Supplies= $98 for the repair.
It turns out that the cable had come loose so they used a zip tie to hold it tight to the latch (see photo) as a repair.
For the person with more time than money - here is a picture of the latch on my 2005 Audi A4 with 3.0 V6. It is real tight but you take the splash guard off the bottom; reach up between the engine and radiator fans with a 18-24 inch screw driver and flip the silver release lever toward the passenger side.
If that is unsuccessful (as in my case) it is possible to remove the center grill from the front of the hood and use a thin 10 mm wrench to loosen the three acorn nuts that hold the catch to the hood. It is a very tedious job that took the Technician about an hour to remove all three nuts.
To remove the center grill you have to reach up from the lower grills and depress 6 plastic tabs at the top of the grill. Starting from an upper corner the tabs are located above the first, third and fifth vertical bars from either edge, you pull down on the tab and push the grill outward.