LinkBack URL
About LinkBacks
Hello,
In a folder I have multiple files. All of them are with the same name but with a date stamp.
For example: Test_20100419
How can i open via macro all the files for the month of April located in this folder?
Hello,
In a folder I have multiple files. All of them are with the same name but with a date stamp.
For example: Test_20100419
How can i open via macro all the files for the month of April located in this folder?
Last edited by Bob@Sun; 04-21-2010 at 04:56 AM.
You should be able to use the DIR function.
Initially this will output valid files to the debug window.
Please Login or Register to view this content.
It is not working properly.
strFilename does not get any value?
Can I assume you modified the folder used in the variable strPath?
If yes start by altering the text used to see if any files are reported.
Please Login or Register to view this content.
The problem was that I did not add "\" at the end of the path.
The code is working great.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks