Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 10th 17, 10:57 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 8
Default IE ActiveX Settings Launched from Excel

Excel 2010 / Windows 7

Currently developing a solution where i want to utilise some HTML5 & Javascript functionality.

I have developed webpage which functions fine working locally within IE11 which applies some javascript and creates a link which downloads a file when clicked.

My plan is to launch the webpage from Excel form encapsulated by the InternetExplorer object by Referencing MicrosoftInternetControls:

Option Explicit
Private WithEvents IE As InternetExplorer


Private Sub cmdLaunch_Click()

Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate ("localWebPage")

end sub

Private Sub IE_OnQuit()

Set IE = Nothing
... do some stuff with saved file

End Sub

However, every time I run the code I get a warning about running ActiveX Controlsand making InternetExplorer my default browser. Even when I accept these when I click on the download link I've created nothing happens as if the link has been disabled (again this works finally when running directly in IE).

I've scrolled through the properties on the IE object and cannot see anything obvious i could change apart from running in Offline mode but that did not make any difference.

I suspect the IE object is a cut down version of IE itself. I know I could access IE or Chrome via a shell command, but then how do I keep a handle on the object so that I can continue processing with Excel when the page is closed?



  #2   Report Post  
Old November 15th 17, 11:18 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 150
Default IE ActiveX Settings Launched from Excel

Hi Armsiee

Have you tried

With Application
..DisplayAlerts = False
End with

Then at the end of your code you need to turn it back on again.

With Application
..DisplayAlerts = True
End with
  #3   Report Post  
Old April 16th 18, 09:11 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2018
Posts: 1
Default IE ActiveX Settings Launched from Excel

Why not just download the file directly from Excel?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel comes up gray screen when first launched G Excel Discussion (Misc queries) 0 November 5th 08 06:36 PM
How to get known by which application Excel was launched? Sergiy Excel Programming 2 October 5th 06 04:00 PM
In Excel, why does my VB not work when launched from IE ? David C Excel Programming 3 March 21st 06 09:46 AM
How do I determine how excel was launched Gilgamesh[_2_] Excel Programming 2 January 21st 05 07:04 AM
Can you tell how Excel is launched? Gail Hurn Excel Programming 3 January 11th 05 05:47 PM


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017