Do Until

[Tigerstyler]

Hi there, I am struggling with a loop;

I want to perform a DO UNTIL loop which will loop UNTIL a certain text file has been opened, say temp.txt for example

Something like:

Do Until Activeworkbook = temp.txt
(Statements)
Loop

Any help would be great, thanks. Be gentle, I'm a newbie.

Tigerstyler

 

[Joe4]

Try

Do Until ActiveWorkbook.Name = "temp.txt"

(you need "name", and all literal names must be put in quotes)

 

[Tigerstyler]

Ahh, so simple! Thanks for your guidance