So I found a code that I thought could work for what I am trying to accomplish but I can't figure out where I am going wrong with it. Here is my code so far...

Please Login or Register  to view this content.
I would like to do the following...

1) Look for an email for the current day with a specific file name
2) From this attachment, take only the worksheets that contain data and add it to an existing workbook
3) Make sure the Name of the worksheet from the attachment is carried over to the new workbook
4) Then tie this into an existing macro to format the worksheet like the rest of the workbook


Does anyone know how I can do this? Can you point me into the direction that will allow me to accomplish this?


I have had some GREAT help from other Forum Users/Gurus and hope I can get some more help now!!!!

Thanks!!!

Dan