Hi
- need a bit more info from you, thanks
1. Are Docs ALWAYS in the same Docs folder?
No the folder is always different..i guess I could always put the file location in a cell and a macro could pick it up.
2. Are Scans ALWAYS in the same Scans folder?
Again the scanned documents are always in a different folder.
3. Do the folders ALWAYS contain the EXACT same number of documents when you run the macro?
The number of documents can vary from 1-50 potentially
E.g. 1 file may have 6
2nd file may have 15
4. Exactly what is a typical file name?- what is the whole name including extension?
- are the first few characters of the name ALWAYS identical and followed by a number
- are numbers of equal length or not
File names are treated as text. You want to match the 10th created image (based on time -which is straightforward) to the Document with filename ending in 10
As is obvious from below we need to be careful in telling VBA which is the 10th document!
The file name to be copied over - the names tend to vary so it's hard to have a consistent file name
Files named f1 to f102 sorted
f1 , f10 , f100 , f101 , f102 , f11 , f12 , f13 , f14 , f15 , f16 , f17 , f18 , f19 , f2 , f20 , f21 , f22 , f23 , f24 , f25 , f26 , f27 , f28 , f29 , f3 , f30 , f31 , f32 , f33 , f34 , f35 , f36 , f37 , f38 , f39 , f4 , f40 , f41 , f42 , f43 , f44 , f45 , f46 , f47 , f48 , f49 , f5 , f50 , f51 , f52 , f53 , f54 , f55 , f56 , f57 , f58 , f59 , f6 , f60 , f61 , f62 , f63 , f64 , f65 , f66 , f67 , f68 , f69 , f7 , f70 , f71 , f72 , f73 , f74 , f75 , f76 , f77 , f78 , f79 , f8 , f80 , f81 , f82 , f83 , f84 , f85 , f86 , f87 , f88 , f89 , f9 , f90 , f91 , f92 , f93 , f94 , f95 , f96 , f97 , f98 , f99
Files named f001 to f102 sorted
f001 , f002 , f003 , f004 , f005 , f006 , f007 , f008 , f009 , f010 , f011 , f012 , f013 , f014 , f015 , f016 , f017 , f018 , f019 , f020 , f021 , f022 , f023 , f024 , f025 , f026 , f027 , f028 , f029 , f030 , f031 , f032 , f033 , f034 , f035 , f036 , f037 , f038 , f039 , f040 , f041 , f042 , f043 , f044 , f045 , f046 , f047 , f048 , f049 , f050 , f051 , f052 , f053 , f054 , f055 , f056 , f057 , f058 , f059 , f060 , f061 , f062 , f063 , f064 , f065 , f066 , f067 , f068 , f069 , f070 , f071 , f072 , f073 , f074 , f075 , f076 , f077 , f078 , f079 , f080 , f081 , f082 , f083 , f084 , f085 , f086 , f087 , f088 , f089 , f090 , f091 , f092 , f093 , f094 , f095 , f096 , f097 , f098 , f099 , f100 , f101 , f102
5. Does the 10th document name in the folder ALWAYS end in 10
- would only be the case if the first document ALWAYS ends in 1
- in other words are we asking VBA to start at 1 every time?
We would be asking the macro to look at the scanned folder, see which one is scanned first by looking at the time. And then copy file number 1.
This should work as long as the scanned documents are scanned in order of file no 1, file no2
6. Would you be able to adopt a different document naming pattern when originally created or are the names determined by another process?
The names are predetermined by the scanning in the printer when you email yourself the copy.
I hope this helps and thank you for taking the time out to reply.