View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.vb.controls,microsoft.public.vb.controls.internet
John Brock John Brock is offline
external usenet poster
 
Posts: 43
Default Can I call an Excel VBA function from within a WebBrowser control?

I have an Excel workbook which can pop up a form that contains a
WebBrowser control. When the user clicks on a button in the web
page that's being displayed in the control, I want a JavaScript
function in the page to call one of the VBA functions in the workbook
and pass it some arguments. Can anyone tell me whether this is
possible, and if so how to do it?

One reason I think it may be possible is that I already know how
to call back to a VB.NET program from a .NET WebBrowser control,
by using the control's ObjectForScripting property and calling
window.external.whatever() in the JavaScript code. It's possible
this is a new feature with .NET, but I am hoping there is some way
to do the same thing from a VBA WebBrowser control, without .NET
being involved.
--
John Brock