sharon3874
Programmer
I am new in VBA. I am sorry in advance if my question doesn't make sense.
I have a word document and there is a button which trigger a macro. in the macro, I want to get some info from reading another doc.
the name of the file is like "additional_links.doc", since I didn't specify the path, so I expected that the macro should read the doc from the current directory. Here is what confused me, sometimes the macro read the file from the current directory, sometimes it read from another directory(I suspect the directory was set somewhere).
It really bothers me that it is not consistent. It read from these 2 directories back and forth, and I couldn't see any pattern of that.
Maybe it does not relate to word VBA, but has anyone have this problem before?
Thanks.
I have a word document and there is a button which trigger a macro. in the macro, I want to get some info from reading another doc.
the name of the file is like "additional_links.doc", since I didn't specify the path, so I expected that the macro should read the doc from the current directory. Here is what confused me, sometimes the macro read the file from the current directory, sometimes it read from another directory(I suspect the directory was set somewhere).
It really bothers me that it is not consistent. It read from these 2 directories back and forth, and I couldn't see any pattern of that.
Maybe it does not relate to word VBA, but has anyone have this problem before?
Thanks.