how can I specific a folder with wildcard criteria and excel will import all the correct files in th

R

Raven

how can I specific a folder with wildcard criteria and excel will
import all the correct files in that folder?

I am completely new to macro programming. After doing a little research
I found out that GetOpenFilename or GetFileList may be able to do
similiar job. But I don't exactly know how to use getopenfilename and
getfilelist doesnt seem to be an valid function in exceel 2003. May you
give me a little instruction? Do you know any online library that gives
detailed explanations of most excel VBA functions?? Thanks.
 
D

Dave Peterson

Without using wild cards, you can search for the files you want and select as
many "correct" files as you need--just click on the first and ctrl-click on
subsequent:


Option Explicit
Sub testme01()

Dim myFileNames As Variant
Dim wkbk As Workbook
Dim fCtr As Long

myFileNames = Application.GetOpenFilename("Excel Files, *.xls", _
MultiSelect:=True)

If IsArray(myFileNames) = False Then
Exit Sub
End If

For fCtr = LBound(myFileNames) To UBound(myFileNames)
Set wkbk = Workbooks.Open(FileName:=myFileNames(fCtr))
'do some things
wkbk.Close savechanges:=True 'or False???
Next fCtr

End Sub
 
Top