Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
source sheet name as a wild card
I was working on this late last night, than I remembered Ron de Bruin page
and he had some written for what I needed. I need a small modification on this code. In the SourceShName line I have it pulling all sheets with the name "Report", but some are my sheet names are called "Report 1, Report 2..." How can I make it look for anything called Report* or something like that. Sub RDB_Copy_Sheet() Dim myFiles As Variant Dim myCountOfFiles As Long myCountOfFiles = Get_File_Names( _ MyPath:="H:\myprojdir\GWIS\Humble\Test\part2", _ Subfolders:=True, _ ExtStr:="*.xl*", _ myReturnedFiles:=myFiles) If myCountOfFiles = 0 Then MsgBox "No files that match the ExtStr in this folder" Exit Sub End If Get_Sheet _ PasteAsValues:=True, _ SourceShName:="Repor*", _ SourceShIndex:=1, _ myReturnedFiles:=myFiles End Sub Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wild card * | Excel Programming | |||
Wild Card? | Excel Programming | |||
Wild Card!!!??? | Excel Programming | |||
Wild card * | Excel Worksheet Functions | |||
Wild card in if then statements | Excel Programming |