topic Open Excel 2007 in Application Development and Automation Discussions

Open Excel 2007

Former Member — Thu, 24 May 2012 05:26:39 GMT

Hi Experts,

I'm using

CREATE OBJECT h_excel 'EXCEL.APPLICATION'.

for opening MS-Excel document.

It is opening in Excel 2003 version.

Is it possible to open the Excel in 2007 Version? How can this be achieved?

Please do help.

Thanks & Regards,
Sowmya

Re: Open Excel 2007

Former Member — Thu, 24 May 2012 05:33:45 GMT

Use this to achieve the upload

Private Declare Sub Sleep Lib "kernel32" _

(ByVal dwMilliseconds As Long)

Sub StartExcel()

Dim objExcel As Object

On Error Resume Next

Set objExcel = GetObject("Excel.Application")

If Err.Number <> 0 Then

Set objWshShell = CreateObject("WScript.Shell")

objWshShell.Run "Excel.exe /s"

Do While Not objExcel Is Nothing

Sleep 250

Set objExcel = GetObject("Excel.Application")

Loop

End If

On Error GoTo 0

objExcel.Visible = True

End Sub

Karthik.R

Re: Open Excel 2007

Former Member — Thu, 24 May 2012 05:40:36 GMT

ABAP OLE2 code pls.

***************** creates an excel application
CREATE OBJECT h_excel 'EXCEL.APPLICATION'.

*Sheet1
CALL METHOD OF
h_excel
'Workbooks' = h_mapl.
SET PROPERTY OF h_excel 'Visible' = 1.

*************** opens a work book
CALL METHOD OF
h_mapl
'Add' = h_map.

How to open the Excel Appln in 2007 version?

Thanks,
Sowmya

Re: Open Excel 2007

Former Member — Thu, 24 May 2012 05:55:37 GMT

Did you enabled the settings for macros in 2007 format

Re: Open Excel 2007

Former Member — Thu, 24 May 2012 06:22:57 GMT

Yes Karthik. It is enabled in 2007.

Re: Open Excel 2007

Former Member — Thu, 24 May 2012 06:36:04 GMT

Check the settings.Click on the office button in the top left hand corner of xls ->Excel options->Trust center-> trust center settings->macro settings->Check "enable all macros"-> and also check the "trust access to vba".

Re: Open Excel 2007

Former Member — Thu, 24 May 2012 06:45:06 GMT

Trust access to VBA is checked, but not "Enable all macros..." is not checked as I dont have authorization.

Re: Open Excel 2007

Former Member — Thu, 24 May 2012 07:06:22 GMT

As per my knowledge if u enable macros.It will work perfectly.If it is disabled contact sys admin

Re: Open Excel 2007

Former Member — Fri, 15 Jun 2012 04:16:16 GMT

The issue is resolved.

It is not with the code.

The issue was with the Server version.

-Thanks & Regards,

Sowmya