Sub Do_The_Recon() ' Dim x As Variant'Used to hold array of filenamesDim i As Integer'Used with x for position in arrayDim J As Integer Dim strFName As String strPath = "\\rgfs\inventory\hall\"'strFName = ActiveWorkbook.Namex = GetFileList(strPath & "2010*.xls") iCol = 1 J = 1 Application.DisplayAlerts = False Select Case IsArray(x)'Application.AlertBeforeOverwriting = FalseCase True 'files found For i = LBound(x) To UBound(x) Workbooks.Open FileName:=strPath & x(i) strFName = ActiveWorkbook.Name' Detail code of process hereActiveWorkbook.Save ActiveWorkbook.Close Next i Case False 'no files found End Select Beep' Application.Visible = TrueEnd Sub
raison d'etre
I have often found bits and snippets of code on the web that I have incorporated into things I'm working on. I take no responsibility for these code samples. Most of them have been laboriously gleaned off of the web, but they're real handy to have quick access to. So bookmark this and enjoy...
JovialJohn
JovialJohn
Thursday, May 13, 2010
A Test
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment