Hi All,
I have a macro coding which help me to get the values from different workbook. i have pasted the code below;
I have a clarification in only two codes mentioned below;
Windows("For July'11 DS Group Dashboard L1-2-3.xls").Activate
Windows("2011-07 DS Dashboard1.xlsm").Activate
The problemfor me his the file name is different for each month. So whati need to use it for specifying file need to be activate. This is the macro for the file will open with browse option after that from the open file value has to taken and pasted in the macro running file.
Can anyone help me on this.
Bookmarks