davidtown23
11-16-2006, 12:06 PM
I am needing code to do the following for a file logging and tracking application.
First. Code to open a certain drive letter on the network. then the user can choose the file, but once it is chosen the code will imput the file name in column B, the File Date in column D and provide a hyperlink to the file in Column E (The text displayed on the hyper link will always be PDF).
(need to use for multiple files to create an ongoing file log)
Second. Once these are filled in, the user will enter the co-worker's id in column C, then code will automatically send the coworker an email notification of the file received. (the coworker's email address is their ID typed in colum C if that helps)
(I have created this shop drawing submittal program, but I want to make it more automated with these codes)
First. Code to open a certain drive letter on the network. then the user can choose the file, but once it is chosen the code will imput the file name in column B, the File Date in column D and provide a hyperlink to the file in Column E (The text displayed on the hyper link will always be PDF).
(need to use for multiple files to create an ongoing file log)
Second. Once these are filled in, the user will enter the co-worker's id in column C, then code will automatically send the coworker an email notification of the file received. (the coworker's email address is their ID typed in colum C if that helps)
(I have created this shop drawing submittal program, but I want to make it more automated with these codes)