Wait Until File Attribute Changes

Topic

New Reply

I have VBA code that changes a file’s attribute from vbHidden to vbNormal and then proceeds to the next line of code.

My challenge is that the code continues prior to the file attribute is changed. This is simply a timing issue. How does one prevent the code from continuing until the file attribute changes?

Thanks,
John

Reply | Quote

Replies

Does it help if you insert a line

DoEvents

between the two instructions?

If not, you could insert a loop

Code:

Do While (file is hidden)
  DoEvents
Loop

Reply | Quote

Hans,

It’s still happening.

My code example is:

[codebox]’File Attributes
FileAttribute = GetAttr(sPathOfSourceFile & strFileName) And vbHidden

If FileAttribute = 2 Then
SetAttr (sPathOfSourceFile & strFileName), vbNormal
Do While GetAttr(sPathOfSourceFile & strFileName) 0
DoEvents
Loop
End If
[/codebox]

Regards,
John

Reply | Quote

I’m sorry, I can’t explain that. What happens if you single-step through the code?

Reply | Quote

I’m sorry, I can’t explain that. What happens if you single-step through the code?

Stepping through the code provides enough time for the file attribute to change. All other lines of code run as expected.

Seem to be a timing difference in seconds.

Regards,
John

Reply | Quote

That was to be expected. But I still don’t understand why the Do While loop doesn’t work…

Reply | Quote