to open all excel files from one folder one by one

[sarsukanth]

Hi All,

i want to open all excel files from one particular folder one by one using excel macros, is it possible, if yes please provide the code.
Thank U in advance for your support.

Thanks & Regards,
Raghukanth

 

[b.downey]

As requested.... This should meet your requirements

Option Explicit
Sub Macro1()
    Dim path As String
    Dim FName As String
    
    path = "C:\Documents and Settings\cpelab\My Documents\"
    
    FName = Dir(path & "*.xls")
    
    Do While FName <> ""
        Workbooks.Open Filename:=FName
        FName = Dir
    Loop
End Sub