Recent content by ugly

Thanks alot for the help. The DoEvents made the difference. Now it is working. Problem Solved. :)

Maybe this can help You. Good luck. Public Function GetTag(strText As String, strTag As String, strTagEnd As String, strControlLine As String) As String Dim intStart As Long Dim intEnd As Long Dim intControlLine As Long intControlLine = strControlLine ' ' Look for where the Tag starts ' If...

I have a WebBrowser Object in a form. I check the ReadyState and when the ReadyState has the value 4 I start processing the text content on the loaded webpage. The problem is that I do not get out of the loop if I do not active a MsgBox. The MsgBox returns 1,2 or 3 the first time the loop i...

Thank you for that advise. I will try out that solution.

I have solved the problem. Do not know if it is a good solution, but it works. Here is the working code: Private Sub ExportToExcel_Click() On Error GoTo Err_ExportToExcel_Click Dim objXL As Object Dim xlWB As Object Dim xlWS As Object Dim i As Integer On Error Resume Next Err.Clear Set objXL...

I am trying to export a record from an Access form to the workbook in Excel. There is no problem when the workbook is not open, but I would like to keep on exporting to the workbook when it is open. I can not figure out to do this without Excel opening a new workbook. Thanks in advance. Here is...