Hi,
I have some code that opens a file with different offset of business days depending on the day of the week. At the moment it will always look in the current month folder, 'strYear' in this case.
I am trying to tweak it so that if the previous file date, 'strFname', falls in the previous month, it searches for it in the previous
months folder.
Any ideas and I just can't seem to get it working.
Please Login or Register to view this content.
Using the Date - 4 for Mondays and Date - 2 for other days of the week in the Format function should automatically throw it to the previous month if the current day of the monthe is 1 or 2. What exactly is not working for you? Can you give an example of the problem? Maybe all you need is an If statement, ieand change your fille path to meet you needs.Please Login or Register to view this content.
Last edited by JLGWhiz; 04-16-2018 at 04:15 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Hello James,
Here is another way to do it that is more readable...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks both.
I used Leith's solution, does the job and tidied up my code. Very much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks