Does anybody know how to embed an Anvil app inside an Excel VBA form?
Yes, I know it sounds weird, because it is, but I really need to do it. Here is some details.
I am in the process of migrating many old tools to Anvil: tons of Excel VBA, some VB6 ActiveX’s and Lotus Notes forms.
In order to make the transition as smooth as possible I would like to slowly replace chunks of old technology with embeded Anvil apps. For example I want to modify an old Lotus or Excel form containing 3-4 subforms, one subform at a time. So the form will show some of its old content for the areas that are not ready in Anvil next to an embedded iframe with new Anvil stuff.
I have used the good old Microsoft WebBrowser control in my forms for decades to embed home made html pages. I tried to use it to embed an Anvil app, but it throws some javascript error and then it shows the anvil.works home page instead of showing my app.
I didn’t find any documentation about it, but I think that control is IE6 compatible, so I have little hope of getting it to work nicely with Anvil.
Any ideas?