-
Jacob, I've tried[VBA] Prompt = "What do you want to search for in the folder: " & vbNewLine & vbNewLine & Path
Title = "Search Criteria Input"
Search = Sheets("Data").TextBox22.Text
Search = Sheets("Data").TextBox23.Text
' InputBox(Prompt, Title)
If Search = "" Then
GoTo Canceled
End If[/VBA]
I get subscript out of range. It wants to search for the workbook name "Data" I guess. The names of the stored files are by date, e.g. 21-10-2004, 22-10-2004, etc. So there are about 30 - 31 files per month stored, in this case in the map Oct. The names of the sheet in the workbooks are called Data and they contain the textboxes
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules