Create an .XLA file

[Greg T]

Parry,

I read that chapter a while back and your post prompted me to check the CD. But in the folder for Chapter 21, there are only two items, neither of which appear to be a utility that would do all of this for you. Are you aware of Walkenbach (or anyone else) already having done up a utility for this? I've got a hum-dinger of an add-in that I suspect is as bloated as the federal budget and I'd like to put it on a diet, so I may end up writing a utility for this for myself (I don't think it'd be all that hard), but thought I'd ask if you'd seen something on the net already.

Regards,

[Daxton A.]

Thank you all for all the good help. Especially you Parry for typing for a while, you didnt have to do that.

Where would books like that be found or I should say, where did ya'll get yours?

[Greg T]

http://j-walk.com/ss/books/index.htm

There are, of course, others, but J-Walk's among the best I've come across.

As to where to get it - since our corp. purchasing (finally) figured out how to use Amazon, I got it there, but I'd say buy whereever you can get your finance manager to sign off on using!

Um - should add, Mr. Excel's offering some new titles. But I'm not familiar with their content.

[parry]

Parry,

I read that chapter a while back and your post prompted me to check the CD. But in the folder for Chapter 21, there are only two items, neither of which appear to be a utility that would do all of this for you. Are you aware of Walkenbach (or anyone else) already having done up a utility for this? I've got a hum-dinger of an add-in that I suspect is as bloated as the federal budget and I'd like to put it on a diet, so I may end up writing a utility for this for myself (I don't think it'd be all that hard), but thought I'd ask if you'd seen something on the net already.

Regards,

Hi Greg not that Im aware of unless JW put this in his PUP utility. Personally I dont create that many add-ins so I havent really worried about it but yes you could create some code - an Add-In in itself :-) - that cleans it all up. I would probably do it myself though as I tend to do extra things like delete all sheets except one to get it down as much as poss.

[Richie(UK)]

Hi guys,

You may be interested in Rob Bovey's Code Cleaner utility - its designed to help clear-up exactly the sort of 'bloat' that JW refers to.

http://www.appspro.com/Utilities/CodeCleaner.htm

[Greg T]

Richie,

Thanks for that link. I downloaded the utility and am looking forward to giving it a try when I have a moment.

Regards,

[Daxton A.]

Thanks also Richie!