Like I said....you must have changed something incorrectly.
You need a "\" on your path!! Look at the code I posted.
path = "C:\work\My Folder\"
Say getFile is "thisTemplate.dot", here is what Documents.Open is seeing:
[vba]Documents.Open Filename:= "C:\work\My FolderthisTemplate.dot"[/vba]In other words, a file named My FolderthisTemplate.dot in the c:\work folder.
BTW: I still think this is crazy crazy. WHY are you having all those files open??????? I am sorry, I just can not believe it is needed. I am not buying that anyone needs to have the number of files open you seem to be talking about.
Could you please tell me why you need to open all those files. Not that that you need to open them, and do stuff. That I can understand. But why you need to have them STAY open.
What on earth could possible require this????? Especially if they really ARE template files.and all files are on screen and ready for me to type in
Something not right here Cheryl.




Reply With Quote