need a macro that only lists files in a directory in the following format
sprint_pcs_general_yyyymmdd or sprint_pcs_general_*
CURRENTLY USING the below code which is returning all files in the directory. I DONT want that, just files that match a pattern
Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
runtime error OBJECT required
Please Login or Register to view this content.
Sorry not all of the code postedPlease Login or Register to view this content.
i modified the code and it now works thanks
I'm glad you found a solution. If you are satisfied with that solution please mark the thread as [SOLVED] using the thread tools at the top.
k how do i close a open file in the format sprint_pcs_general_* using a macro
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks