check for duplicate before appending to new file

macropod · #1 05-16-2013, 08:29 AM

You can easily-enough use the Instr function to test whether the xml file contains your image name. If it returns anything greater than 0, the image name is already there.

rcVBA · #2 05-16-2013, 09:34 AM

strMatchesFile is the file that the image names are being stored in. I am trying to use InStr like this:

Code:

myNoDupes = InStr(strMatchOrig, strMatchesFile)

but strMatchesFile is searched as the file path and name, how can I search the contents of strMatchesFile? I can do the Instr at the point where strMatchesFile is open for Append As #hFile
I'm having some trouble getting the content of the file instead of the file path/name

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cannot check/uncheck check box but added check box	learn2office	Word	1	11-27-2012 02:02 AM
Appending the filename with the current date	sheeand	Word VBA	2	05-14-2012 05:18 AM
Word Macro That Checks a Check Box Form Field When File Print is Executed	DKerne	Word VBA	4	06-09-2011 11:54 AM
Appending Word Docs	Frank	Word	0	02-26-2010 04:38 PM
Saving Word document creates a duplicate transparent file	bbailey	Word	0	12-05-2009 10:54 PM