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

Problem in Excel with OLE

Go to solution
Former Member

‎2009 Feb 11 3:38 PM

0 Likes
486

Hello,

i´m downloading some data into excel with Ole way. I need to write data in some differents sheets. Do anyone knows how to active other sheet than the first one?

Thank you.

1 ACCEPTED SOLUTION
Read only

Go to solution
former_member156446
Active Contributor

‎2009 Feb 11 3:41 PM

0 Likes
455

Hello,

i´m downloading some data into excel with Ole way. I need to write data in some differents sheets. Do anyone knows how to active other sheet than the first one?

Thank you.

Reply
2 REPLIES 2
Read only

Go to solution
former_member156446
Active Contributor

‎2009 Feb 11 3:41 PM

0 Likes
456

Read only

Go to solution
Former Member

‎2009 Mar 06 7:19 AM

0 Likes
455

Try with this.

CREATE OBJECT gs_excel 'EXCEL.APPLICATION' .

SET PROPERTY OF gs_excel 'Visible' = 1 .

GET PROPERTY OF gs_excel 'Workbooks' = gs_wbooklist .

GET PROPERTY OF gs_wbooklist 'Application' = gs_application .

SET PROPERTY OF gs_application 'SheetsInNewWorkbook' = 1 .

CALL METHOD OF gs_wbooklist 'Add' = gs_wbook .

GET PROPERTY OF gs_application 'ActiveSheet' = gs_activesheet .

SET PROPERTY OF gs_activesheet 'Name' = gv_sheet_name .