sckumar
01-29-2010, 11:39 AM
Hi,
Could some one please help me on this:
Description:
This should be a one- or two-line description of the outcome after the code has been run.
There are file names vertically in worksheet(find attached sample) and I have files of these names in folder.
On file name in the cell and file name in the folder matches, the sheets in the file should move to the file.
Discussion:
Provide a real-life scenario in which this code can be used. You can use as much space as you like here. Be friendly if you can, remembering that we need to cater to people who do not understand VBA.
There will be many sample files which consist of file name’s vertically in one folder (find sample attached) and there are files in the another folder with these names consists of details in many sheets.
So I want to have a macro where, it should ask for path twice one for opening of sample files in the folder and another path for source folder which has file details.
Criteria : if the file name in the sample file and file name in folder matches(first 40 characters) the sheets in the file should move or copy to the sample file.
Code:
I have codes for opening sample files and I need your support for looping through the cells and on blank cell in sample file while looping it should close the file.
Please find codes in the sample file attached.
Thanks in advace.
CK-,
Could some one please help me on this:
Description:
This should be a one- or two-line description of the outcome after the code has been run.
There are file names vertically in worksheet(find attached sample) and I have files of these names in folder.
On file name in the cell and file name in the folder matches, the sheets in the file should move to the file.
Discussion:
Provide a real-life scenario in which this code can be used. You can use as much space as you like here. Be friendly if you can, remembering that we need to cater to people who do not understand VBA.
There will be many sample files which consist of file name’s vertically in one folder (find sample attached) and there are files in the another folder with these names consists of details in many sheets.
So I want to have a macro where, it should ask for path twice one for opening of sample files in the folder and another path for source folder which has file details.
Criteria : if the file name in the sample file and file name in folder matches(first 40 characters) the sheets in the file should move or copy to the sample file.
Code:
I have codes for opening sample files and I need your support for looping through the cells and on blank cell in sample file while looping it should close the file.
Please find codes in the sample file attached.
Thanks in advace.
CK-,