Search results for query: *

Basically I want to know how to import a web page onto a form using vb. It would be the same as the "get external data" in excel but without using excel.

Thanks It worked

IvanMoala Thanks for the advice I tried what you said and got the false option to work without a compile error but The application still comes back every 15 min. help

I've tried: Application.OnTime Now + TimeValue("00:15:00"), "OtherSub", schedule:=False Application.OnTime Now + TimeValue("00:15:00"), "OtherSub", , schedule:=False Application.OnTime Now + TimeValue("00:15:00")...

I am using the subs: Sub MySub() Call OtherSub Application.OnTime Now + TimeValue("00:15:00"), "MySub" End Sub Sub OncePerHour() Application.OnTime TimeValue("08:59:00"), "OtherSub" Application.OnTime TimeValue("09:59:00")...

This is my complete sub Private Sub WorkBook_Activate() Dim StrTime As String StrTime = Time() Call RefreshDavoxData Sheets("Davox").QueryTables(1).BackgroundQuery = False 'any code enter here will not be run until the refresh is finished Sheet3.Range("O3").Value =...

Thanks for the reply I actually found out how to do it today also. Sheets("Sheet1").QueryTables(1).BackgroundQuery = False will stop the macro from continueing until the refresh is completely finished.

I have a workbook that imports data from a web page. I want to refresh the data every time the workbook is open and then execute code when the data is completely refreshed. I want to be sure the data is refreshed completely before the code runs. I know how to execute code on startup of a...