I have macro that builds and attaches files from a folder that is designated. The problem is an excel file gets added to that folder that I don't need when my email gets generated. can you instruct the code to ignore attaching that file. that way I don't have manually delete it every time the email is generated. this is what I have that send the email.
The file is Named "rawsurveys.xls"
Please Login or Register to view this content.
thanks
Last edited by AliGW; 06-17-2018 at 02:27 PM.
Thank you for attempting to add code tags. Please note that the closing tag requires a forward slash / rather than a backslash \. I have amended this for you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
.
Delete or Comment Out these lines :
Please Login or Register to view this content.
I want the other files in the folder just not the one file outlined above....
You have marked this thread as solved - is it?
In case it isn't.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks