Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All,
Having made a habit of utilizing this newsgroup for "programming lessons", and finding it invaluable, I finally have a question for which I cannot find an answer. I think my answer is "find another way to do this without using FileSearch." Yet, I must ask.... I am using typical FileSearch code (from this newsgroup) to locate the latest file in a folder. In my application, this can be done via filenames (mmyy at the beginning of each file in the folder). (Therein lies my answer) The code worked a number of times with no problems, then starting giving the following problem: The .LookIn value stays at "My Documents", (when moused over while stepping through the code) instead of the coded folder on the other side of the = sign. Anyone have any ideas on why this is happening? With Application.FileSearch .NewSearch .LookIn = "C:\Some\Long\String\" (mouse over .LookIn and get "C:\My Documents" Looking forward to your experience and suggestions. Randy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Do File Open and default to the MyDocuments dialog box | Excel Programming | |||
Lookin property of the FileSearch object | New Users to Excel | |||
Problem with setting a R / W property, FileSearch, LookIn | Excel Programming | |||
how can I display the file location (ie:C/mydocuments..)print | Excel Discussion (Misc queries) | |||
Cannot assign value to Filesearch.Lookin | Excel Programming |