chinna
03-25-2008, 02:01 PM
Hi all,
I am new to this Discussion Board, hope I can get some help here. I am new to Excel/VBA, I am facing a problem.
Description of the Macro's functionality : We recieve a file on daily basis, by clubbing information on this file with another one we prepare a report.
Say we recieve file 1, which will be named jlm0324.xls, we have to do some Vlookup and join it with another file which is saved as kkd.xls (this file name never changes, so no worries).
Is there a way that I can make the Macro smart enough to pick up the file with latest date saved in the folder?
Not only this, in the report we have to Copy/paste some information from report prepared from prior day, as such the macro i have now shows "Active window" in the code and the numbers keep changing if the report is opened along with someother spreadsheet.
Any help in this matter would be greatly appreciated. TIA
I am new to this Discussion Board, hope I can get some help here. I am new to Excel/VBA, I am facing a problem.
Description of the Macro's functionality : We recieve a file on daily basis, by clubbing information on this file with another one we prepare a report.
Say we recieve file 1, which will be named jlm0324.xls, we have to do some Vlookup and join it with another file which is saved as kkd.xls (this file name never changes, so no worries).
Is there a way that I can make the Macro smart enough to pick up the file with latest date saved in the folder?
Not only this, in the report we have to Copy/paste some information from report prepared from prior day, as such the macro i have now shows "Active window" in the code and the numbers keep changing if the report is opened along with someother spreadsheet.
Any help in this matter would be greatly appreciated. TIA