Below is the command for end of file. Good luck. When you get finished with your code, post it here...
While Not EOF(FileVariable)'while not end of file
'do something
Wend 'end while
That sounds like a security issue. If you don't want that message to pop up, change the macro security to low.
You have to control over where other people have their security levels set, so this won't help them. They can set their security levels to low also, but beware of receiving files...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.