Filename Extensions required in VBA
I am pretty stumped on the following which may perhaps turn out to be a piece of cake?
I wrote some VBA code in Word to look through files to trade certain bits of information. I had written in the activate code to switch between the files i.e.
* windows("test").activate
This worked fine. However, I came across one machine in particular that kept erroring when running the same code. I found out that if I changed the code to say i.e.:
* windows("test.docx").activate
It then ran ok on this machine. However, it became really fussy when I tried to run the code on read-only files. The other machines would run based on the following:
* windows("test (read-only).docx).activate
but on the other machine it had to entered as
* windows("test.docx (read-only).activate
in order to run.
Does anyone know how I can turn the extension off? So, that machine does not need the extension written in the code?
Thanks!!!!
|