Hallo,
is it possible to start in Excel the Infor Add In with a VB Script (inclusive the credentials)
Best regards
Bernd
Hello @bernd-krichbaum ,
it depends what you mean by start the add-in.
In case it is already deployed and the ribbon tab or the show task pane button is visible, then you can use VBA script and call Application.SendKeys calling the keyboard shortcuts to navigate/execute the ribbon buttons.Theoretically same can be used to even authenticate.
In case you mean deploying/inserting - I am not sure, maybe with similar approach but definitely not somehow through special VBA API (at least like half year ago there was none such API method). MS is discouraging to mix the VBA with Office Add-ins.
However, maybe it could be possible via Office Scripts (although last time I checked there was no such method too)
HTH,
V.
Hallo Vit Holy,
thank you for your advice.
I think the sendkey method can work in this case.
But do you have a sendkey for the Infor addin in Excel or must I create one?
Bernd Krichbaum
Hello,
Not sure what exactly do you mean with 'do you have sendkey for....'
There are default shortcuts in Office when you press alt key, e.g. alt + H navigates to home tab (on my env.) and Infor EPM addin had then shortcut Y1 (again on my environment), so I could send keys Alt, H, Y1
With April version and ribbon support we have introduced shortcut for login pageSo once the add-in is deployed you can use SendKeys with '+%L' in Excel VBA to open the task pane with Log in page.
I have found my shortcut. It is Alt + 5.
Thank you for your support.
