Smart View / VBA / Open Form

Menagerp

Hi there,

I try to open a web form in smart view (11.1.2.5.710) with vba methods

lRet = HypCreateConnectionEx("Planning", "server", app, "Plan1", "/Forms/Form1", "http://server:19000/HyperionPlanning/SmartView", "My conn", user, pass, "Descr My conn", "", "")

lRet = HypUIConnect(Empty, user, pass, "My conn")

lRet = HypSetActiveConnection("My conn")

lRet = HypOpenForm(Empty, "/Forms", "Form1", dimlist, memlist)

HypOpenForm ends with a -41 error (Provider not supported)

Anyone has an idea ?

Thanks a lot.

Regards.

Menagerp

Hello, yes i've always see this doc, but with new reading, my problem is finally solved. I change few things in HypCreateConnectionEx(database set to "", form path as "/Forms")

Documentation isn't really clear on this point.

Thanks for your help.

See below:

lRet = HypCreateConnectionEx("Planning", "server", app, "", "/Forms", "http://server:19000/HyperionPlanning/SmartView", "My conn", user, pass, "Descr My conn", "", "")

Robert Angel

Per the manual try; -

lRet = HypOpenForm(Empty, "/Forms/Form1", "Form1", dimlist, memlist)

Menagerp

Hi Robert,

Thanks for your reply. Sorry, it doesn't work, always the same error.

If i look at the sheet property "sheet info" in excel, sheet type is defined as "Empty", when i open a form manually, sheet type is set to "Form".

Regards

Robert Angel

Have you seen; -

https://www.eehelp.com/question/hypopenform-anyone-able-to-get-this-working/

HypOpenForm - Anyone able to get this to work? - Smart View

Menagerp

Hello, yes i've always see this doc, but with new reading, my problem is finally solved. I change few things in HypCreateConnectionEx(database set to "", form path as "/Forms")

Documentation isn't really clear on this point.

Thanks for your help.

See below:

lRet = HypCreateConnectionEx("Planning", "server", app, "", "/Forms", "http://server:19000/HyperionPlanning/SmartView", "My conn", user, pass, "Descr My conn", "", "")