Hello! I have a query for you all. I have a spreadsheet that lists an attachment number amongst other things. I also have a directory that has all of the attachment files and those file names match the attachment number from the spreadsheet.
I want to be able to click on a link or button and have the attachment open based on the matching attachment number field. For instance, the attachment field in the Excel workbook located in, let's say P:\documents\DCTM Backup, may be REQEQ-1234-001. In an associated folder, let's say P:\documents\DCTM Backup\Attachments, I have a document titled REQEQ-1234-001.msg. Note: the attachment may be .msg, .zip, .pdf, or .doc. I have very little coding experience, so I apologize for coming to you so very green.
Any assistance that you can offer would be greatly appreciated. I'm not sure if I should be using the HYPERLINK function, or if I should use a button and macro, or if it even matters. AND, I have no idea how to capture the dynamic find and open functionality that I need. Thank you in advance!!
I want to be able to click on a link or button and have the attachment open based on the matching attachment number field. For instance, the attachment field in the Excel workbook located in, let's say P:\documents\DCTM Backup, may be REQEQ-1234-001. In an associated folder, let's say P:\documents\DCTM Backup\Attachments, I have a document titled REQEQ-1234-001.msg. Note: the attachment may be .msg, .zip, .pdf, or .doc. I have very little coding experience, so I apologize for coming to you so very green.
Any assistance that you can offer would be greatly appreciated. I'm not sure if I should be using the HYPERLINK function, or if I should use a button and macro, or if it even matters. AND, I have no idea how to capture the dynamic find and open functionality that I need. Thank you in advance!!