VBA: 2007 ==> 2010, How Badly Broken?

[(PeteCresswell)]

I've got a fairly-complicated spreadsheet that I create via MS Access
VBA.

Originally developed under Office 2003, then moved to 2007 with no
apparent problems.

We recently had Office 2010 imposed on us without time for adequate
testing and this one sheet looks like a disaster to me.

Excel is throwing "The selection contains multiple data values...."
warnings when .Merge is applied to a range (which it was not under
2003/2007) and the sheet is missing data and generally looking like a
dog's breakfast.

I suppose the only thing to do is re-develop the code from scratch and
hope... but deadlines loom....

But has anybody else run into this? I'm grasping at straws here.....
maybe a Library or .DLL or .OCX reference or something..... ?

 

[GS]

You do know that Excel 2010 uses VBA7, right? I have not found any
issues with my projects developed in Excel 2003 running under Excel
2010, but the VBA was originally Excel not Access, and so only refs the
Excel object model.

Otherwise, the error message is ambiguous at best since most
'selections' that are not single cells do contain multiple data values!

--
-
Garry

Free Usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[(PeteCresswell)]

Per GS:

You do know that Excel 2010 uses VBA7, right? I have not found any
issues with my projects developed in Excel 2003 running under Excel
2010, but the VBA was originally Excel not Access, and so only refs the
Excel object model.

I had no clue.

I'm doing maintenance development on the Access 2003 app using Access
2010, but the DB format is still Access 2000.

Maybe that's a clue for me.

Otherwise, the error message is ambiguous at best since most
'selections' that are not single cells do contain multiple data values!

For me, it was more that the error was being thrown under 2010 and not
under 2007/2003 than anything more specific.

Right now, I'm trying to pick the app apart piece-by-piece to see where
the damage begins. Maybe a look at converting the Access app to 2010
format is in order..... Maybe...

 

[(PeteCresswell)]

Per (PeteCresswell):

Right now, I'm trying to pick the app apart piece-by-piece to see where
the damage begins.

Looking like my method of introducing subtotals is working under 2003,
but not under 2010.

 

[GS]

Per (PeteCresswell):

Looking like my method of introducing subtotals is working under
2003, but not under 2010.

Just curious why you don't import the MDB data via Excel VBA rather
than create the spreadsheet from Access?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[(PeteCresswell)]

Per GS:

Just curious why you don't import the MDB data via Excel VBA rather
than create the spreadsheet from Access?

The basic application is MS Access. It's a bond trading app.

Reporting-wise, the users have a strong preference for the reports to be
rendered as Excel spreadsheets - often with substantial bells and
whistles.

User clicks "Reports".... user selects desired report.... user fills in
parms, selects fund names.... hits "OK".... next thing they see is an
Excel window containing the report.

 

[GS]

Per GS:

The basic application is MS Access. It's a bond trading app.

Reporting-wise, the users have a strong preference for the reports to be
rendered as Excel spreadsheets - often with substantial bells and
whistles.

User clicks "Reports".... user selects desired report.... user fills in
parms, selects fund names.... hits "OK".... next thing they see is an
Excel window containing the report.

Well that seems fittingly appropriate to the task! Perhaps 2010 doesn't
like (as you say) the way subtotals are done. Is it possible the values
involved are mixed data types?

--
-
Garry

Free Usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[(PeteCresswell)]

Per GS:

Well that seems fittingly appropriate to the task! Perhaps 2010 doesn't
like (as you say) the way subtotals are done. Is it possible the values
involved are mixed data types?

The subtotals are, of course, one of the Bells/Whistles I was going on
about.

I think my first task is to replicate the addition of the subtotals
manually, record a macro, and see if it's an different from the code I
have in place.

Problem so far is that I cannot replicate the subtotals manually....
OTOH, I've been having other issues that have prevented me from giving
that the attention it needs. Hopefully some time next week....

I'll report back on what I find or do not find.