Windows("06 11 299805 All Companies JRNL Bal Errors Claims.xlsx").Activate
Is there a way to get around so that the above file name can be changed automatically? For example, The file name will be changed monthtly to reflect the current month (IE, 06 11 to 07 11). Somehow I want to put a formula so that it picks up the new file name automatically. Any suggestions? Thanks.
If it will always be the current month, you could do this:
Windows(Format(Date,"mm yy") & " 299805 All Companies JRNL Bal Errors Claims.xlsx").Activate
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks