Office 2007

[Allan P. London, CPA]

I attempted to run a very complex Excel App (over 200 lines of Code) on
Excel 2007 Beta. I noted two problems immediately:



1. The VBA code for Past-Special-Add is flakey so consolidated results don't
balance?

2. The code that refreshes pivot tables does not work?



As soon as I fix these problems, I am sure other problems will turn up. Is
there a place where 2007 problems are discussed?



Thanks,



Allan P. London, CPA

 

[RB Smissaert]

200 lines, very complex?
I have an application with 3 .xla files and a number of dll files.
Main .xla file has over 81000 lines of code.
Have run this now in 2007 and no problem at all, but haven't looked
at pivots yet.

RBS

 

[Allan P. London, CPA]

Woops, I met 2000 lines. But 81000 Lines??? your shlong must reach to the
floor!

 

[RB Smissaert]

Not sure what a shlong is, but yes, it is a lot of code.
Reassuring though is that it all works fine in 2007.

RBS

 

[Guest]

If you are a registered member of the beta program then you can log this in
the bug tracker. If you are not then if you would like me to I can report
this to Microsoft if you are seeing this in beta 2