Thanks Peter, Yes Set SapGuiAuto = CreateObject("Excel.Sheet") works. Why "SAPGUI" must be an ActiveXObject? Is it by design?
Clarence 2013/9/2 Peter Eberlein <pet....@refofd.verwalt-berlin.de> > > Hi Clarence, > Am 02.09.2013 08:47, schrieb Clarence GUO: > > Hi~ >> I'm totally green at StarBasic and VBA. Now I have a question about >> CreateObject. I installed SAP and have below macros. >> >> Dim SapGuiAuto As Variant >> Set SapGuiAuto = CreateObject("SAPGUI") >> >> "SAPGUI" must be an ActiveXObject. > > Does Set SapGuiAuto = CreateObject("Excel.Sheet") work? > > Regards Peter > > > ------------------------------**------------------------------**--------- > To unsubscribe, e-mail: > dev-unsubscribe@openoffice.**apache.org<dev-unsubscr...@openoffice.apache.org> > For additional commands, e-mail: dev-h...@openoffice.apache.org > >