Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

excel 2007 inplace with different worksheets

Former Member
0 Kudos

Hi,

has anybody an idea, why our construction:

"using Excel inplace to arrange data from our report to different worksheets in 1 workbook"

works without any problems with Windows XP and SAPGUI 6.4 but not with Windows 7 and Excel 2007?

The result is, that all data, which should be sent to different worksheets is sent to just 1 worksheet and in that worksheet the different datasets are overlaying each other.

Juergen

1 ACCEPTED SOLUTION

Sandra_Rossi
Active Contributor
0 Kudos

did you check SAP notes?

5 REPLIES 5

Sandra_Rossi
Active Contributor
0 Kudos

did you check SAP notes?

0 Kudos

Yes I did, but I coulldn't find any suitable hint

0 Kudos

could you try with SAPGUI 7.10 latest patch?

You can also send an OSS message to SAP support. When it's solved, tell us what was the issue, how you solved.

0 Kudos

thanks for the answer

We installed already SAP-GUI 7.1 with patch 15 but the problem hasn't disappeared

As soon I find a solution I will post it here.

Juergen

Former Member
0 Kudos

Hi communinity,

my problem has been solved by SAP and Microsoft.

CALL METHOD OF worksheets 'SELECT' exporting #1 = save_z_sheet .

  • Kopieren des ausgewählten Arbeitsblattes

  • CALL METHOD OF worksheets 'Copy' . (Original unter Excel 2003)

  • mit Excel 2007/2010

CALL METHOD OF worksheets 'Copy' exporting #1 = worksheet .