Each day a receive an email containing an .xls link which has various tabs of data.
What i would like to do is, when the email arrives, to automatically open and save the sheet to the hard drive, in a particular location with the date added on the end!
ie: newfile010416.xls
im very new to vba and dont have a lot of experience...
can you help?
What i would like to do is, when the email arrives, to automatically open and save the sheet to the hard drive, in a particular location with the date added on the end!
ie: newfile010416.xls
im very new to vba and dont have a lot of experience...
can you help?