mas_lerdanch
Board Regular
- Joined
- Jun 25, 2007
- Messages
- 64
http://www.colletts.co.uk/img/WebMrExcel.jpg
I have the above spreadsheet in operation - the data is pulled from a network place like below.
='\\Venice\cmh\Shared\D - Database\DatabaseDownloads\[csvExport-WorkApplications.csv]csvExport-WorkApplications'!D6
1. I would like the emails (all results in Email Column) to automatically be email links.
2. The file names (Fil 1 & File 2 Columns)to be proceeded by the file path and link to the documents that are automatically downloaded from the web to a local folder. The data is created in a .csv file online every 4 hours and is downloaded along with the attached files to a network drive.
Is this possible?
mas
I have the above spreadsheet in operation - the data is pulled from a network place like below.
='\\Venice\cmh\Shared\D - Database\DatabaseDownloads\[csvExport-WorkApplications.csv]csvExport-WorkApplications'!D6
1. I would like the emails (all results in Email Column) to automatically be email links.
2. The file names (Fil 1 & File 2 Columns)to be proceeded by the file path and link to the documents that are automatically downloaded from the web to a local folder. The data is created in a .csv file online every 4 hours and is downloaded along with the attached files to a network drive.
Is this possible?
mas
Last edited by a moderator: