Recent content by Hamyatta

John, This sounds pretty good to me... The challenge lies in "cycling" through the files one by one... because all the files have different names... Any idea on how one can write code to cycle through n files with different names..? Thanks :) Cheers

PHV, I have tried few codes but this is quite a challenge.. I have to open all of them at the same time as there over 50 files with different names... Then copy respective cells (8 cells, one at the time), paste it into an existing excel file, then close that source file and move to the...

Hey PHV, Thanks in advance!! I have to open all of them at the same time as there over 50 files with different names... Regards, H

Hi All, Can anyone please show me how to alternate between two or three excel files using VBA... For instance Open Files File A, File B, File C, and File D THEN copy from File A, then paste into File X, then close File A copy from File B, then paste into File X, then close File B copy from...

Hi Gerry, Sincere apologies for the impression... I was attempting to show the answers to your questions more clearly. I had no intention to shout at you... Again sorry. You are also right that one of my answers was confusing.. -- In fact once the codes start to open the files, it opens...

Hi Gerry, Great to hear from you Gerry. Please find below answers tyo your questions... ( I will use large letters, sorry...to differentiate). Thanks again. A - are you trying to give a choice to the users on what file to open? NO I AM GIVING USERS THE CHOICE ON WHICH FILE TO OPEN.. B - are...

Thanks Fumei, I am using the following code to first SEARCH, then OPEN all excel files within a given folder.. Here is the code I have. Any help sincerely appreciated with this.... -------------------------------------- Sub GetFileIII() Dim lngCount As Long With Application.FileSearch...

-- I am using the following string to open "ANY" excel file in a specific folder.. Workbooks.Open Filename:= _ "C:\Excel Data Extract\AnyFile.xls" -- Would it be better to use this one? "C:\Excel Data Extract\ &''"& '.xls'" Any ideas..?? THANKS!!!!