Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

ole2_object 4 or more sheets?

Former Member

‎2007 Sep 18 9:51 AM

0 Likes
304

Hi,

i wanna know, if its possible to make an excelsheet with more than 3 sheets?

I tested this, with the result, that the excelsheet has only 3 sheets and the third one is overwritten with the last one.

Does anybody knows some advice?

Is anywhere some ole2-reference available?

Thanx

Tony

Hi,

i wanna know, if its possible to make an excelsheet with more than 3 sheets?

I tested this, with the result, that the excelsheet has only 3 sheets and the third one is overwritten with the last one.

Does anybody knows some advice?

Is anywhere some ole2-reference available?

Thanx

Tony

Reply
1 REPLY 1
Read only

messier31
Active Contributor

‎2007 Sep 18 10:31 AM

0 Likes
288

Hi,

Yes it is possible to have more than 3 sheets. Infact I have seen cases where mor than 10 sheet are created dynamically.

Also you can use following doc for easy reference

<b><a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/204d1bb8-489d-2910-d0b5-cdddb3227820">An Easy reference to OLE automation</a></b>

Enjoy SAP.

Pankaj Singh.