Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to Workbook(s) received by email
I am trying to save some time and possibility of error, by linking cells in
an inhouse workbook, to cells in a number of workbooks received by email. The workbooks receivd by email have the same name each day. I want to eliminate the need to save these files, as this is unnecessary. The issue is that the emails and template could be used by different users, who obviously have different user id's and their temp internet folders also have different names/file paths. Is there any way of specifiying in the formula that I want to link to the active/open workbook and not the version in the temp internet file, as this often gives incorrect results, or am I barking up the wrong tree. Thanks in advance Richard |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to Workbook(s) received by email
The active/open workbook received by email is the same as the temp file.
When you open an attachment a temp file is created because it is not saved anywhere else. The only way to link to something not in the temp file is to save the file somewhere else. One thing you could do, since the file name is the same everyday, instead of opening directly from the email, save the file. Then everyday just save over the other file (replace the file during the save, not delete then save new). This might preserve the links in your current workbook (not sure though!). -- JNW "Richard" wrote: I am trying to save some time and possibility of error, by linking cells in an inhouse workbook, to cells in a number of workbooks received by email. The workbooks receivd by email have the same name each day. I want to eliminate the need to save these files, as this is unnecessary. The issue is that the emails and template could be used by different users, who obviously have different user id's and their temp internet folders also have different names/file paths. Is there any way of specifiying in the formula that I want to link to the active/open workbook and not the version in the temp internet file, as this often gives incorrect results, or am I barking up the wrong tree. Thanks in advance Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link to email address--not wanted | Links and Linking in Excel | |||
Automatic Email Link | Excel Discussion (Misc queries) | |||
when I email my workbook, it is received as 'read only' | Excel Discussion (Misc queries) | |||
link email to drop down list | Excel Discussion (Misc queries) | |||
Is there a way to link a received outlook email to a cell? | Excel Worksheet Functions |