View Single Post
 
Old 08-06-2010, 10:15 AM
bollivar_corona bollivar_corona is offline Windows XP Office 2007
Novice
 
Join Date: Aug 2010
Posts: 2
bollivar_corona is on a distinguished road
Default 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!!!!
Reply With Quote