0

Is it possible to open an excel file from an e-mail via VBA in excel?

example setup:

  • daily mail with an excel file attached

Need:

  • Opening that attached excel file from excel (via VBA) and saving it to a local location

Is the opening of an excel file stored in outlook even possible in VBA Excel?

Community
  • 1
  • 1
Bulki
  • 700
  • 1
  • 10
  • 30
  • possible duplicate of [Download attachment from Outlook and Open in Excel](http://stackoverflow.com/questions/11781320/download-attachment-from-outlook-and-open-in-excel) – Siddharth Rout Nov 07 '13 at 08:49

1 Answers1

0

Check that link:

Save attachments to a folder and rename them

To open an Excel file in VBA:

Workbooks.Open Filename:="C:\\attachment.xls"
Community
  • 1
  • 1
Rami
  • 6,727
  • 1
  • 19
  • 19