Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search File Windows in same Excel
Copy the below procedure to your code and call as
ActivateBookwithKeyword "flow" Sub ActivateBookwithKeyword(strSearch As String) For intTemp = 1 To Workbooks.Count If InStr(1, Workbooks(intTemp).Name, strSearch, 1) < 0 Then Workbooks(intTemp).Activate Exit Sub End If Next End Sub If this post helps click Yes --------------- Jacob Skaria "Elton Law" wrote: Dear Expert, Every day I need to open 6 files below. They are .... Workflow_090424.Xls Reval_090424.Xls Schedule_090424.Xls Income_090424.Xls DateRaw_090424.Xls Uploading_090424.Xls Duties are easy, routine and clerical ... Just copy and paste, move, sum .... All can be done by Excel macros easily. But the problem is that ...... VB scripts have to clearly mention the file name so that it can do something on it. Now all system generated files must add system date at the end of the file. That's ... Uploading_090424.xls Fixed VB scripts cannot make it .... Someone taught me to use following InputBox UserValue = InputBox("Which File to be used?") Windows(UserValue).Activate But the files are too Long to type all of them in one by one on daily basis. Is it possible to write in VB scripts so that it can automatically enable (activate) the windows with key words such as "Workflow", "Schedule" ? Then Activate that windows (files) with that Key words. Thanks so much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
windows xp search for numbers within an xls file | Excel Discussion (Misc queries) | |||
Search for Excel worksheet in Windows Explorer using dollar value | Excel Discussion (Misc queries) | |||
Can Excel search for workbook data in a Windows folder? | Excel Discussion (Misc queries) | |||
Windows search in Excel with autofilter | Excel Discussion (Misc queries) | |||
Use Windows Script to run Windows Explorer Search? | Excel Programming |