Effective Care for the Armed Forces and Veterans Act of 2007

Effective Care for the Armed Forces and Veterans Act of 2007 - Prohibits the Secretary of Defense, during a period of a U.S. major military conflict, from: (1) subjecting work performed by an employee of a Department of Defense (DOD) medical facility or an employee of a private contractor of such facility to public-private competition; or (2) converting such employee or the work performed to private contractor performance. Allows an exception to prevent a negative impact on the provision of services.

Requires a study by the Comptroller General on competitive outsourcing activities at DOD medical facilities.

Provides: (1) a minimum budget for DOD medical services during periods of major military conflicts; and (2) a limitation on the implementation of a recommendation for the closure of Walter Reed Army Medical Center.

Requires the Secretary to: (1) assign at least one case manager for every 20 recovering servicemembers; (2) screen every servicemember returning from deployment in Operations Iraqi Freedom or Enduring Freedom for traumatic brain injury (requiring two related studies); and (3) require DOD medical records management systems to communicate with such systems of the Department of Veterans Affairs (VA).

Directs the Secretary of Veterans Affairs to assess the VA's ability to meet the long-term care needs of veterans over the next 50 years.