try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook
On Sun, Jul 3, 2011 at 11:33 AM, Nasim wrote:
> Hi Ashish,
>
> First of all congrats! You are a big help to all of us :)
>
> Also, Thanks a lot for your hel
Hi Ashish,
First of all congrats! You are a big help to all of us :)
Also, Thanks a lot for your help. you. I tweaked your code a bit and
got it to work the way I needed. now I have another problem:
I am combining files from different location into one sheet (a new
workbook). The list of files t
try this
select the folder in which files are saved
Function SelectFolder(Optional Title As String, Optional TopFolder _
As String) As String
Dim objShell As New Shell32.Shell
Dim objFolder As Shell32.Folder
Set objFolder = objShell.BrowseForFolder _
(0, Title, 1, TopFolder)
If Not objFolder Is
Hi,
I am using excel 2010. I have searched internet and have come up with
below codes to:
1- Open a folder
2- Loop through excel files and open them one by one.
3- Check existence of path in opened file (path is in the sheet called
"Path", cell B2 of opened file)
4- Give me a message if path does