Excel Macros

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?

**open32** · 12-07-2007, 02:40 PM

Quote:

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?

(Im not to good with Macros and have never tried this)

In the VB window if you hit ctrl+F it brings up a window with some search options. Assuming there is some kind of common route with all the links (there should be) you can try to search for that.

Sorry if this suggestion isnt useful.

Blackmask · 12-07-2007, 05:56 PM

Thanks Open, you're right, that would work and certainly be quicker than reading every line of the macro.

It looks like they've had some real VB wizards there in the past who have written macros to do all kinds of things. I'm not a fan of using macros to this level. It's great at the time, but on a long term basis it becomes a specialist thing and the spreadsheets are difficult to change.

wannabe · 05-03-2008, 06:41 PM

You might be able to create a macro to automatically parse all your files' macros looking for whatever it is you're looking for. It would require a lot more knowledge than I currently have, but I think it would work.

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?

05-03-2008, 06:41 PM	#4 (permalink)
wannabe Lacey's Man Newbie Join Date: Mar 2008 Posts: 35 My Profile	You might be able to create a macro to automatically parse all your files' macros looking for whatever it is you're looking for. It would require a lot more knowledge than I currently have, but I think it would work. Last edited by wannabe : 05-03-2008 at 06:41 PM.

12-07-2007, 05:56 PM	#3 (permalink)
Blackmask Protector of Inanity Join Date: May 2002 Location: Australia Posts: 6,158 My Profile	Thanks Open, you're right, that would work and certainly be quicker than reading every line of the macro. It looks like they've had some real VB wizards there in the past who have written macros to do all kinds of things. I'm not a fan of using macros to this level. It's great at the time, but on a long term basis it becomes a specialist thing and the spreadsheets are difficult to change.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)