I am having a problem with setting the value in a TextBox in VB 6.0. Here is my code where the problem occurs:
txtStatus.Text = "Saving Spreadsheet as mah_enctr.txt. Please Wait..."
.ActiveWorkbook.SaveAs "I:\Working_Folder\MAH Encounters\mah_enctr.txt", xlTextPrinter
--> txtStatus.Text = "Creating MAH Provider and Service Files. Please Wait..."
hProcess = OpenProcess(PROCESS_QUERY_INFORMATION, 1, _
GetExitCodeProcess hProcess, RetVal
Loop While RetVal = STILL_ACTIVE
Everything works fine up until the second line that tries to set the value of the TextBox. The program seems to just totally ignore
this line. I tried adding the SetFocus line to see if that would fix the problem, but it didn't do anything different. If I set a breakpoint
and step through this section of code it works fine, but when I run it normally it never Changes the TextBox after the SaveAs. Has
anyone seen anything like this before, or have any suggestions on what the problem might be?