perryarrow
Technical User
Low level user of Excel macros and links here. Have fair amount of VB programming experience. Trying to shorten the learning curve. Need to link to a directory and find a specific file based on a name of a file in the spreadsheet. Not sure if this can be better done using link commands or better done with a macro. I think macro.
The mission: Create an intelligent link.
Background: An Excel file that lists some documents and thier decription etc.. One of the columns is the docments' file name. The file name is, lets say, 6 numbers ex. 245256.fil. The names in this column are to be a link to a directory that stores the files. When user selects the file name the file opens.
The Catch: The actual file names would have an additional number appended to the original 6 numbers. Reflecting a Rev number. So the above mentioned file name, 245256.fil, might actually have 3 files in the directory with numbers 2452560.fil, 2452561.fil 2452562.fil etc..
The link is to open the file with the highest Rev number.
Any guidence would be appreciated.
P.L.
The mission: Create an intelligent link.
Background: An Excel file that lists some documents and thier decription etc.. One of the columns is the docments' file name. The file name is, lets say, 6 numbers ex. 245256.fil. The names in this column are to be a link to a directory that stores the files. When user selects the file name the file opens.
The Catch: The actual file names would have an additional number appended to the original 6 numbers. Reflecting a Rev number. So the above mentioned file name, 245256.fil, might actually have 3 files in the directory with numbers 2452560.fil, 2452561.fil 2452562.fil etc..
The link is to open the file with the highest Rev number.
Any guidence would be appreciated.
P.L.