FanHost Forums - View Single Post

Blackmask · 12-06-2007, 07:35 AM

I have the project from hell coming up after Xmas where I'll be sorting and reorganising a sharedrive at work that contains around 13000 files. Some are easy, just presentations and the like, but there's also a lot of Excel spreadsheets that may have links in them. A standard link is fine, just check the links and re align them.

It's the fancy macros that some contain that concern me. Does anyone know if there's a quick easy way to check if Macros in Excel contain links or will I have to read every line of VB to find them?

12-06-2007, 07:35 AM	#1 (permalink)
Blackmask Protector of Inanity Join Date: May 2002 Location: Australia Posts: 6,158 My Profile	Excel Macros I have the project from hell coming up after Xmas where I'll be sorting and reorganising a sharedrive at work that contains around 13000 files. Some are easy, just presentations and the like, but there's also a lot of Excel spreadsheets that may have links in them. A standard link is fine, just check the links and re align them. It's the fancy macros that some contain that concern me. Does anyone know if there's a quick easy way to check if Macros in Excel contain links or will I have to read every line of VB to find them?