Open Common named excel files from 2 different folders

[Ashwini.A]

Hello,

I am trying to open the excel files from 2 different folders. Folder1 contains standard templates and Folder2 contains input files. Folder2 may has more than one files matching with same names.
please somebody help me to get this through VBA code.

 

[Manohar M G]

Hi,

This code is to open "xls" file..If u want other format like "xlt" you have change the text(from "xls" to "xlt") Check this. If you any error let me know.

myLabel:
Filename = Application.GetOpenFilename("All files (*.xls*),*.xls*")
If Filename = False Then
Exit Sub
End If
Set Wbk_St = Workbooks.Open(Filename)

 

[Ashwini.A]

Thanks for the reply Manohar.
It does works fine. But i want to open the files automatically without any prompt/user browse window.
I've an array of files like;
file(1) = "Test1"
file(2) = "Test2" upto 15.
Here Test1 is present in 2 different folders. i want to all files "Filename = Test1" from both the folders. <here i'll do some other manipulations> then close all and go for Test2 files.

Thanks in advance.

 

[Manohar M G]

Hi,

Let you know what i'm understand,

1. You have 15 files in folder 2. & 1st file will be present in both the folders. ---> this is right..?
2. you have to access all 15 files at a time without using Dialog box & finally u have to close all the 15 files except second file(u have to open 2nd file) ---> this is what u r sayin..?
3. then i have 1 question what will be the name of each file...?

 

[Ashwini.A]

1. I have 15 files in folder1. Filenames are like AP01,AP02,AR02,APCRC04,AR01,AO04 and so on...

Folder2 contains more than 15 files. here also filemanes macthes with files in Folder1. like 20110601_AP02.xls, 20110607_AP01.xls, 2011_06_01_AP02.xls

see here we have totally 3 "AP02" files in both folder1 and folder2. i want all those 3 to be opened.

Then loop for "AP01" files and then to "APCRC04" files....

hope i made u clear.

 

[Manohar M G]

Hi,

Almost i'm clear about that..

1. U have 2 folders.. each folder contains 15 files or more than that..
If the file (AP01) in folder 1 then match the same file (AP01) in folder 2 also (like 20110601_AP01).If the file matches in folder 1 & in folder 2 then open 2 files . if it is more than 4 or 5 files matches it should be open all the 4 or 5 files..
2. Once the file (AP01) process to be done it next go for other file (AP02).


I think this is right...??? or any changes in this..?

 

[Ashwini.A]

Yes
Thats Correct.. After the process in AP02 is done, close all AP02 files and open other matching files...

 

[Ashwini.A]

Please do let me know if you need any more information. and please help me out.