SmartIndent in Excel2007

User avatar
ErikJan
BronzeLounger
Posts: 1324
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

SmartIndent in Excel2007

Post by ErikJan »

I'm old and years behind, hope you can forgive some obvious questions in the next couple of posts about Excel 2007 (which, I know, is already almost outdated itself, I might just upgrade to 2010 soon... here @ home but @ work I'm stuck to 2003 and by year end for four years probably to 2007)...

I always use(d) Stephen Bullen's SmartIndent to tidy up my VB(A) code. Now, in my Excel 2007 / Win7(64) I wanted to re-install but Stephen's website mentions Excel 2003 and nothing beyond that... am I out of luck?

User avatar
mbarron
2StarLounger
Posts: 112
Joined: 25 Jan 2010, 20:19

Re: SmartIndent in Excel2007

Post by mbarron »

You can install it if you are using 2007. It works on my machine at least. I'm using SmartIndenter v3.5 currently.

User avatar
HansV
Administrator
Posts: 79526
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: SmartIndent in Excel2007

Post by HansV »

In addition to mbarron's reply: the Visual Basic Editor in Office 2007 is still the same as in previous versions (except that the VBA help has become even worse than it was in Office 2003; it's virtually useless now), so add-ins for the VBE that worked in previous versions should still work in Office 2007.
Best wishes,
Hans

User avatar
ErikJan
BronzeLounger
Posts: 1324
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Re: SmartIndent in Excel2007

Post by ErikJan »

That works... thanks!

User avatar
rory
5StarLounger
Posts: 826
Joined: 24 Jan 2010, 15:56

Re: SmartIndent in Excel2007

Post by rory »

HansV wrote:(except that the VBA help has become even worse than it was in Office 2003; it's virtually useless now)
The Offline Help is a lot better than the Online one. Not saying a lot though...
Regards,
Rory

User avatar
HansV
Administrator
Posts: 79526
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: SmartIndent in Excel2007

Post by HansV »

I agree that the offline help is better than the laughably inadequate online help. But since the excellent help files for the Excel macro language, quality has gone downhill with each new version. Same for Word and Access... :sad:
Best wishes,
Hans