Control Internet Explorer from VBA











up vote
0
down vote

favorite












I have created a macro/userform that creates an html file and want Internet Explorer 11 to show the page.

When you use the userform you create new data that should be shown on the page. How do I refresh the page on IE11?



I tried using meta refresh, but if the userform writes the page at the moment IE refreshes the page goes blank and stops from refreshing.



Another method I tried is sendkeys but it doesn't seem to work. 



AppActivate "The page - Internet Explorer"

SendKeys "{F5}", True


nothing happens.



Are there any other options to make sure the page is refreshed and always visible? (meaning don't refresh when the file is in use by the userform)






vba refresh internet-explorer-11







share|improve this question




























    up vote
    0
    down vote

    favorite












    I have created a macro/userform that creates an html file and want Internet Explorer 11 to show the page.

    When you use the userform you create new data that should be shown on the page. How do I refresh the page on IE11?



    I tried using meta refresh, but if the userform writes the page at the moment IE refreshes the page goes blank and stops from refreshing.



    Another method I tried is sendkeys but it doesn't seem to work. 



    AppActivate "The page - Internet Explorer"
    
SendKeys "{F5}", True


    nothing happens.



    Are there any other options to make sure the page is refreshed and always visible? (meaning don't refresh when the file is in use by the userform)






    vba refresh internet-explorer-11







    share|improve this question


























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I have created a macro/userform that creates an html file and want Internet Explorer 11 to show the page.

      When you use the userform you create new data that should be shown on the page. How do I refresh the page on IE11?



      I tried using meta refresh, but if the userform writes the page at the moment IE refreshes the page goes blank and stops from refreshing.



      Another method I tried is sendkeys but it doesn't seem to work. 



      AppActivate "The page - Internet Explorer"
      
SendKeys "{F5}", True


      nothing happens.



      Are there any other options to make sure the page is refreshed and always visible? (meaning don't refresh when the file is in use by the userform)






      vba refresh internet-explorer-11







      share|improve this question















      I have created a macro/userform that creates an html file and want Internet Explorer 11 to show the page.

      When you use the userform you create new data that should be shown on the page. How do I refresh the page on IE11?



      I tried using meta refresh, but if the userform writes the page at the moment IE refreshes the page goes blank and stops from refreshing.



      Another method I tried is sendkeys but it doesn't seem to work. 



      AppActivate "The page - Internet Explorer"
      
SendKeys "{F5}", True


      nothing happens.



      Are there any other options to make sure the page is refreshed and always visible? (meaning don't refresh when the file is in use by the userform)






      vba refresh internet-explorer-11




      vba refresh internet-explorer-11






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 20 hours ago









      QHarr

      25.7k81839




      25.7k81839










      asked 21 hours ago









      Andreas

      14.3k31441




      14.3k31441
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          We need to check your code to understand your issue, In general You can try to move this refresh code and put it after the all code in user form. so it will get executed after the execution of all user form code.






          Sub demo()
          

          
  Dim page As New InternetExplorer
          
  page.Navigate "www.microsoft.com"
          
  
          
  Do
          
  Loop Until page.ReadyState = READYSTATE_COMPLETE
          
    
          
    If Not page.Busy Or page.ReadyState = 4 Then
          
        page.Refresh
          
    End If
          
  page.Visible = True
          
End Sub





          You can make a test with above code. If issue persist then try to provide a sample code to produce the issue.



          We will try to make a test with it and try to find a solution for it.






          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














             

            draft saved


            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372041%2fcontrol-internet-explorer-from-vba%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote













            We need to check your code to understand your issue, In general You can try to move this refresh code and put it after the all code in user form. so it will get executed after the execution of all user form code.






            Sub demo()
            

            
  Dim page As New InternetExplorer
            
  page.Navigate "www.microsoft.com"
            
  
            
  Do
            
  Loop Until page.ReadyState = READYSTATE_COMPLETE
            
    
            
    If Not page.Busy Or page.ReadyState = 4 Then
            
        page.Refresh
            
    End If
            
  page.Visible = True
            
End Sub





            You can make a test with above code. If issue persist then try to provide a sample code to produce the issue.



            We will try to make a test with it and try to find a solution for it.






            share|improve this answer

























              up vote
              0
              down vote













              We need to check your code to understand your issue, In general You can try to move this refresh code and put it after the all code in user form. so it will get executed after the execution of all user form code.






              Sub demo()
              

              
  Dim page As New InternetExplorer
              
  page.Navigate "www.microsoft.com"
              
  
              
  Do
              
  Loop Until page.ReadyState = READYSTATE_COMPLETE
              
    
              
    If Not page.Busy Or page.ReadyState = 4 Then
              
        page.Refresh
              
    End If
              
  page.Visible = True
              
End Sub





              You can make a test with above code. If issue persist then try to provide a sample code to produce the issue.



              We will try to make a test with it and try to find a solution for it.






              share|improve this answer























                up vote
                0
                down vote










                up vote
                0
                down vote









                We need to check your code to understand your issue, In general You can try to move this refresh code and put it after the all code in user form. so it will get executed after the execution of all user form code.






                Sub demo()
                

                
  Dim page As New InternetExplorer
                
  page.Navigate "www.microsoft.com"
                
  
                
  Do
                
  Loop Until page.ReadyState = READYSTATE_COMPLETE
                
    
                
    If Not page.Busy Or page.ReadyState = 4 Then
                
        page.Refresh
                
    End If
                
  page.Visible = True
                
End Sub





                You can make a test with above code. If issue persist then try to provide a sample code to produce the issue.



                We will try to make a test with it and try to find a solution for it.






                share|improve this answer












                We need to check your code to understand your issue, In general You can try to move this refresh code and put it after the all code in user form. so it will get executed after the execution of all user form code.






                Sub demo()
                

                
  Dim page As New InternetExplorer
                
  page.Navigate "www.microsoft.com"
                
  
                
  Do
                
  Loop Until page.ReadyState = READYSTATE_COMPLETE
                
    
                
    If Not page.Busy Or page.ReadyState = 4 Then
                
        page.Refresh
                
    End If
                
  page.Visible = True
                
End Sub





                You can make a test with above code. If issue persist then try to provide a sample code to produce the issue.



                We will try to make a test with it and try to find a solution for it. 






                Sub demo()
                

                
  Dim page As New InternetExplorer
                
  page.Navigate "www.microsoft.com"
                
  
                
  Do
                
  Loop Until page.ReadyState = READYSTATE_COMPLETE
                
    
                
    If Not page.Busy Or page.ReadyState = 4 Then
                
        page.Refresh
                
    End If
                
  page.Visible = True
                
End Sub





                Sub demo()
                

                
  Dim page As New InternetExplorer
                
  page.Navigate "www.microsoft.com"
                
  
                
  Do
                
  Loop Until page.ReadyState = READYSTATE_COMPLETE
                
    
                
    If Not page.Busy Or page.ReadyState = 4 Then
                
        page.Refresh
                
    End If
                
  page.Visible = True
                
End Sub






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 4 hours ago









                Deepak-MSFT

                44815




                44815






























                     

                    draft saved


                    draft discarded



















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53372041%2fcontrol-internet-explorer-from-vba%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Can a sorcerer learn a 5th-level spell early by creating spell slots using the Font of Magic feature?

                    Image
                    28 6 $begingroup$ Per the Font of Magic feature, sorcerer can use Flexible Casting to create 5th-level spell slots at level 7, even though they are not typically available until level 9. You can transform unexpended sorcery points into one spell slot as a bonus action on your turn. The Creating Spell Slots table shows the cost of creating a spell slot of [5th level is 7] If such a sorcerer levels up while still having this 5th-level spell slot, can they choose a 5th-level spell as the spell they gain upon levelling up? The Spellcasting feature states: Additionally, when you gain a level in this class, you can choose one of the sorcerer spells you know and replace it with another spell from the sorcerer spell list, which also must be of a level for which you have spell slots.
                    Read more

                    Does disintegrating a polymorphed enemy still kill it after the 2018 errata?

                    Image
                    up vote 13 down vote favorite 1 After the 2018 errata, the disintegrate spell description now reads: A creature targeted by this spell must make a Dexterity saving throw. On a failed save, the target takes 10d6 + 40 force damage. The target is disintegrated if this damage leaves it with 0 hit points. If you were to polymorph an enemy into a rat and then disintegrate it, would the enemy be disintegrated or would it just return to its original form? I know that for Druids, it’s not an instant kill anymore, but is this the case for polymorph as well? dnd-5e spells polymorph errata share | improve this question edited 18 hours ago
                    Read more

                    A Topological Invariant for $pi_3(U(n))$

                    Image
                    3 3 $begingroup$ Recently, I saw a construction of topological invariant for $pi_3(U(n))$ with $ngeq 2$ : $$ N=frac{1}{24pi^2}int_{S^3} d^3x epsilon^{ijk} Tr[(U^{-1}partial_{x_i}U)(U^{-1}partial_{x_j}U)(U^{-1}partial_{x_k}U)] , $$ where $Uin U(n)$ depends on $boldsymbol{x}=(x_1,x_2,x_3)in S^3$ , $epsilon^{ijk}$ is the Levi-Civita symbol, $i,j,k=1,2,3$ , and the duplicated indexes are summed over. It is claimed that $N$ is an integer, but why? Update 02/02/2019 I think I got an argument for $n=2$ . In this case, $U=e^{i varphi} q$ with $qin SU(2)$ . Due to the trace and the Levi-Civita symbol in $N$ , $varphi$ does not contribute to $N$ . As $Tr[q^{dagger}partial_i q]=0$ and $(q^{dagger}partial_i q)^{dagger}=-q^{dagger}partial_i q$ , $q^{dagger}partial_i q$ in geneeral has the form $q^{dagger}partia
                    Read more