M
mishkarella
Hi
I'm not even sure this is entirely an Excel question but anyway...every
day I get emailed an Excel attachment of new data that I'm then to add
to a master worksheet of all the previous emailed data.
Up until now I have been opening the attachment, copying the contents
and pasting into the master worksheet.
Is there any way I can auto extract the contents of the attachment and
consolidate into one spreadsheet, so it becomes an automated update of
the master spreadsheet? Kind of like parsing an email's text into a
spreadsheet, but extracting the contents of the attachment, rather than
the email's text.
I'm using Outlook on XP, and the file name of each day's attachment is
constant, ie. no unique name.
Thanks for any input.
I'm not even sure this is entirely an Excel question but anyway...every
day I get emailed an Excel attachment of new data that I'm then to add
to a master worksheet of all the previous emailed data.
Up until now I have been opening the attachment, copying the contents
and pasting into the master worksheet.
Is there any way I can auto extract the contents of the attachment and
consolidate into one spreadsheet, so it becomes an automated update of
the master spreadsheet? Kind of like parsing an email's text into a
spreadsheet, but extracting the contents of the attachment, rather than
the email's text.
I'm using Outlook on XP, and the file name of each day's attachment is
constant, ie. no unique name.
Thanks for any input.