as i can not open .xlsm, only .xls, i can not look at your workbook
perhaps you can use application.ontime to create a delay, between calls to the web pull, until successful
it always depends if you want excel to go into unresponsive while waiting
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
no i can only open early version (.xls) anyway need to see what code you are using, so need the macros to be included
SaveAs excel 2003 or earlier
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
End With
If Not Err.Number = 0 Then
Application.OnTime Now + TimeSerial(0, 1, 0), "webpull"
Err.Clear
Exit Sub
End If
Call Macro152 'Transfers record sheet
put on error resume next at the top of procedure
note this will only work if an error is generated
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
not sure if it has encountered non result issue as yet
put some counter or output to log so you can see what is happening
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
[RESOLVED] Web Pull Call - Wait - Call - proceed
Reply With Quote
