Script in worked in Excel 2003 not working in Excel 2007

[Former Member]

Hi Experts,

I am getting error when running a script in Excel 2007; it worked fine with Excel 2003.

Error at line 4:

Set sapguiauto = GetObject("SAPGUI")

Set application = sapguiauto.GetScriptingEngine

Set connection = application.Children(0)

Set session = connection.Children(0)

Can you guys please help.

Thanks..

Regards,

Mani

[Former Member]

Hi Mani,

Have you check the VB references? -Tools-->References

BR

D