topic Re: About OLE2 Excel programming in Application Development and Automation Discussions

About OLE2 Excel programming

Former Member — Fri, 24 Mar 2006 02:04:22 GMT

How can I set the property 'PageSetup.Zomm' = False through an OLE2 Excel object in ABAP?

I tried:

set property of PageSetup 'Zoom' = 0 .

set property of PageSetup 'Zoom' = 'False' .

But doesn't work.

How can I transfer a Boolean value to an OLE2 object?

Thanks for any hint.

Re: About OLE2 Excel programming

Former Member — Fri, 24 Mar 2006 03:15:13 GMT

Dan,

Others of us have had the same issue.

See this thread for help...

Re: About OLE2 Excel programming

Former Member — Mon, 27 Mar 2006 00:33:14 GMT

Thanks!

But is there any better approach?

Re: About OLE2 Excel programming

Former Member — Mon, 27 Mar 2006 01:55:23 GMT

If you review the Internet for this issue, you will see that MANY Windows developers have experienced the same issue.

It appears that Microsoft has not allowed this parameter to set through OLE automation. I would call it a "bug"... perhaps in the form of an oversight.

One other way that I considered was to have SAP download a custom VB app that would be "fired" after the data was placed into Excel. The app would use the Windows handle of the newly, created Excel instance and send it keystrokes to activate the Zoom.

Unfortunately, managing Windows handles across apps can be a pain. So I did not write the VB app to do it. I choose the simpler approach.

Let me know if you come across any other findings.

Re: About OLE2 Excel programming

Former Member — Mon, 27 Mar 2006 01:56:35 GMT

Perhaps you could contact Microsoft directly for advice or to log an issue for their Products division.

Re: About OLE2 Excel programming

Former Member — Mon, 03 Apr 2006 01:15:56 GMT

Thanks again!

I will try