If you look, you can still find Office 2007 downloads. Visio is a little harder. here are some links you can try:
Dec 09, 2012 Office Visio Professional 2007 is helping IT and business professionals worldwide visualize, analyze, and communicate complex information, systems, and processes. Extend Office Visio 2007. Microsoft Office Visio 2007 is a diagramming and data visualization solution that makes it easy for IT and business professionals to visualize, analyze, and communicate complex information, systems and processes. Microsoft Visio Professional 2007 makes creating sophisticated diagrams easy. Beautifully organized diagrams in just minutes Visio Professional 2007 features built-in templates, shapes, and more so you can turn ideas, lists, and data into beautifully organized diagrams in just minutes.
NOTE: if you do not have the installation file on an “official” MS installation disk, you should burn it to one or more DVDs for future use. And at the same time, write down the product key on the DVD. You need both items for future installations, say after your computer crashes and you have re-installed windows. At that point you won’t be able to extract it from the registry and won’t remember where the online account is.
Office 2010 / 2007 Download locations - http://answers.microsoft.com/en-us/office/forum/office_2010-office_install/here-are-the-download-locations-for-office-2010/ac67aa2f-dc1c-46f4-8b1d-ca00b3f02a18
www.getmicrosoftoffice.com - 2007 Office downloads (confirmed)
https://www.microsoft.com/office/downloads/ - Full Retail FPP download
Microsoft Office Visio 2007 Product Key
https://www.microsoft.com/office/backup/en-us/default.mspx - Media-less License Kit MLK download, Office 2007 Backup disk
http://trial.trymicrosoftoffice.com/msft-orpc/default.aspx?culture=en-US - MLK download/backup for Home & Student (be sure to say yes to the question!)
http://www.heidoc.net/joomla/technology-science/microsoft/51-office-2007-direct-download-links - Here you'll find official download links for the installation files of most Office 2007 suites, single components and language packs in 38 languages. All packages are officially hosted by Digital River, Microsoft's online distribution partner.
Microsoft Visio Professional 2007 Product Key
http://e5.onthehub.com/WebStore/OfferingsOfMajorVersionList.aspx?ws=8a314897-739b-e011-969d-0030487d8897&vsro=8&pmv=e63fd66c-93d1-db11-9b6d-0010c6cb78ad&cmi_mnuMain=bdba23cf-e05e-e011-971f-0030487d8897&JSEnabled=1 – They still have Viso 2007 Pro but you need an account. If you contact them and you already have a product key you MAY be able to convince them to give/sell you the installation file.