LinkBack URL
About LinkBacks
Hi,
I want a Macro that opens a folders, brows through the files and opens only those that in the file name have the date between 26/10/2012 - 09/11/2012 (Today).
Is that possible. If so, how could I do that?
Thanks a lot!
Hi,
I want a Macro that opens a folders, brows through the files and opens only those that in the file name have the date between 26/10/2012 - 09/11/2012 (Today).
Is that possible. If so, how could I do that?
Thanks a lot!
Yes, it's possible, but paste here some filenames
If solved remember to mark Thread as solved
Will your start date be static? For e.g. Today will keep changing as you run the macro on different days, will 26/10 always be 26/10?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
All files names will have the same format:
Shipment- No. Shipment-City-Date (Year-Month-Day)
Example: Shipment-34566-LAREDO-2012-11-10
The No.Shipment, City and Date will vary accordingly. Those files will be added daily to the folder so I want a macro that only opens the files from the past 15 days and performs a subroutine.
Thanks a lot!
No extension (.xls) in your filenames ? please attach a view of your folder
Hi,
I attach a view of my folder. For the moment the files are extension .xlsm but thye are to be modified to be saved as .xls.
Hope you can help me!
Regards
Once the files are opened, action taken, they can be re-saved as .xls. What actions do you need to be performed?
Hi,
I just need to copy some rows from the files that are going to be opened and close them without saving anything (there will be no changes performed to the files).
Regards!!
But you said you want to save them as .xls?
These rows need to be copied to 1 file? Which are the ranges to be copied?
Sorry what I meant is that the files are going to be in the folder with extension .xls. I am performing a few tests and that is why they are saved as .xlsm, but I don´t want the macro to perform that change of extension. What I want the macro to do is open the files that have in the filename the past 15 days, copy certian rows (the ranges to be copied are not going to be static because they may vary depending on each file) and close the files.
Regards!!
So how would the macro determine which rows need to be copied?
It will copy until the last cell that has text. I got that figured out, what I don´t know is the opening files part!
Can you provide a few more examples of your file names?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks