Fun: Longest Macro

[Greg Truby]

Well, that's easy enough to remedy. Just convince management that all of the users of your application need to upgrade to 2010 and that they need to give you the time to make the additional customizations. [However I asked Andy & he said that he hasn't yet had the time to make his tool handle the new stuff for XL2010 ]

http://msdn.microsoft.com/en-us/library/ee691832.aspx

 

[hatman]

Umm,yeah, we got upgraded to Excel 2007 in summer 2009. I expect to be upgraded to 2010 no sooner than 2012.

 

[Greg Truby]

Umm,yeah, we got upgraded to Excel 2007 in summer 2009. I expect to be upgraded to 2010 no sooner than 2012.

Hey - the jar of blueberry preserves is half-full my friend, not half-empty. By then there's a good chance Andy will have the 2010 stuff built into his tool. [to self: when am I gonna learn to quit making food references here - every time I do, I want a snack...]

 

[hatman]

Pro: Andy's tool will be updated.
Con: I won't remember what functions I once had on teh context menu.

 

[SuperFerret]

Imagine locking down each and every aspect of the user instraface with Excel, then exposing selected interfaces through your own front end. Re-write File-> Opne, and File->Save, as well as Copy, Paste, and everything in-between. It's very daunting, but when done carefully, it can actually SAVE you a bunch of work.

Sounds like the old system I worked on years ago, whenever it broke it asked you to restart Excel and I never knew why
Although if that is the case why they couldn't get it to communicate with another Excel spreadsheet for customer documents I'll never know (or the other way round)

 

[Gerald Higgins]

You shouldn't go over 64K in a code module.

Apologies for dragging this thread back a couple of days but, as someone who is still learning the basics of VBA, I don't know how to work out the size of a code module. Is there an easy way to do this ? Thanks in advance.

 

[RoryA]

Export it as a text file, or I think some of the code documenters will tell you.

 

[Gerald Higgins]

OK thanks Rory, I can do the export to text file bit. I'm sorry for being thick on this, but will the size of the text file be (roughly) the same as what Excel thinks it is, in respect of Greg's 64k figure ?

 

[RoryA]

Yes, should be near enough.

 

[Greg Truby]

Apologies for dragging this thread back a couple of days but, as someone who is still learning the basics of VBA, I don't know how to work out the size of a code module. Is there an easy way to do this ? Thanks in advance.

I'm surprised Rory didn't mention this, cuz it's how I do it...

http://www.oaltd.co.uk/VBETools/