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

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" wrote in message
...
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

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


"RB Smissaert" wrote in message
...
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" wrote in message
...
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

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

"Allan P. London, CPA" wrote in message
...
Woops, I met 2000 lines. But 81000 Lines??? your shlong must reach to the
floor!


"RB Smissaert" wrote in message
...
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" wrote in message
...
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

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

--
www.alignment-systems.com


"Allan P. London, CPA" wrote:

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