Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-04-2010, 10:33 PM
bollivar_corona bollivar_corona is offline Filename Extensions required in VBA Windows XP Filename Extensions required in VBA Office 2007
Novice
Filename Extensions required in VBA
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for automatically adding filename without .doc RPM7 Word VBA 0 04-29-2010 01:43 AM
Filename in footer Dixon Word 3 09-24-2009 09:12 AM
Reference to an external filename which changes frequently roooberta Word 0 12-11-2008 07:33 AM
Newbie - extensions only working in root directory rlcarr71 Misc 0 04-24-2006 07:26 AM
SERVER 2002 EXTENSIONS ISSUE jasonst Misc 0 12-02-2005 08:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft