Hi All,
I am struggling with code to open a selection of files based on range 'Control'!B10:D10 but without error so if one of the cells has now file then take no action or error. once they have been opened they are then all closed before the next part of code emails them out.
Thanks for any input
Danny
sounds like you should be able to add "on error resume next" anywhere near the top of your code and be good to go...
i'd caution - it looks like your code is going to try to create 9 extra emails you were not intending
Set rngEntries = ActiveSheet.Range("B7:D10")
should probably be
Set rngEntries = ActiveSheet.Range("B7:D7")
Last edited by simarui; 04-17-2015 at 02:25 PM.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Hi,
thanks for that the On Error bit worked and as you said created blank emails, can if statements be used in code so that within the larger range if their was no email listed it would not produce the email. I am just trying to fix the range so it is easier to manage
Maybe check if file exist
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hi Mike,
thank for the input but it just says file not found, in changing the range to B10:D10 it stops the whole email process
I will close this thread and repost as my needs have changed slightly and the code I have now is virtually done.
Thanks
All for the Help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks