ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 Problem (https://www.excelbanter.com/excel-programming/373659-excel-2007-problem.html)

Allan P. London, CPA

Excel 2007 Problem
 
I have been testing my winery forecasting software on Excell 2007. Bata2
fixed several problems but there is still a MAJOR BUG. The
Paste|Special|Add fails wihen used in VBA. It seems to work manually, but
when I step through the code, it will only add to empty cells in the copy
add range.

Everything works fine on Excell 2003. This is going to create a problem for
all folks that combine financial data in what is called a "roll-up", so it
is a real problem! You financial guys will know what I am talking about.

Now my question - How do I report this to the folks at Microsoft. By the
way, I was able to fix the problem using the consolidation feature, but it
is much more complicated.

If you are really interested and want to see it fail, download the VIRTUAL
Winery V3 from my web site and try it. Do a "Roll-up" - the results are
nonesense! The code password is "fermatafermata" and the sheet passwords
are "xwit".

Thanks for your help.

Allan P. London
http://alondon.com




Gary Keramidas

Excel 2007 Problem
 
i was going to download it, but i don't really want to fill out a form to be
able to.

--


Gary


"Allan P. London, CPA" wrote in message
...
I have been testing my winery forecasting software on Excell 2007. Bata2 fixed
several problems but there is still a MAJOR BUG. The Paste|Special|Add fails
wihen used in VBA. It seems to work manually, but when I step through the
code, it will only add to empty cells in the copy add range.

Everything works fine on Excell 2003. This is going to create a problem for
all folks that combine financial data in what is called a "roll-up", so it is
a real problem! You financial guys will know what I am talking about.

Now my question - How do I report this to the folks at Microsoft. By the way,
I was able to fix the problem using the consolidation feature, but it is much
more complicated.

If you are really interested and want to see it fail, download the VIRTUAL
Winery V3 from my web site and try it. Do a "Roll-up" - the results are
nonesense! The code password is "fermatafermata" and the sheet passwords are
"xwit".

Thanks for your help.

Allan P. London
http://alondon.com






All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com