How to refer to a file in the same directory

Guessed · #2 06-07-2023, 04:42 PM

You will need to be explicit in providing the actual path. In VBA you could use

Code:

ThisDocument.Path & Application.PathSeparator & "My Doc.docx"  'or
ActiveDocument.Path & Application.PathSeparator & "My Doc.docx"

ThisDocument is the file where the macro is sitting
ActiveDocument is the document which is currently active (on top)
Application.PathSeparator is a tortuous way to write \ but we use it in case the code is being used on a Mac, in which case it becomes ":" because that is how a Mac separates folders

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Strip out numbers from file names in a directory.	JustJim	Word VBA	2	10-20-2021 06:40 PM
Using Word VBA to change file names in a directory	sg11	Word VBA	4	03-22-2018 04:25 AM
Changing file directory from a temp folder	dwirony	Word VBA	6	12-13-2016 09:41 PM
Replacing jpg file in each file of a directory	hklein	Word VBA	4	10-14-2013 04:40 PM
Auto-File Naming/ Default Directory Saves	sgill32	Word	2	11-06-2008 02:12 PM