Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Stuart,
With the problematic workbook open, in the VBE: Tools | References and check that you have a reference set to the MS office object library. --- Regards, Norman "Stuart" wrote in message ... Have just moved up from 98 to xp and have found that the following code will not work, any ideas why ??? at the ".FileName" line i am getting a runtime error 5 "Invalid procedure call or argument" It only throws this fault if it finds a file, i.e. if I used "*.hhh" the problem does not arisre because it will not find any such files With Application.FileSearch .LookIn = "C:\Myfile\Preview" .SearchSubFolders = False .FileName = "*.jpg" .Execute For i = 1 To .FoundFiles.Count Next i End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |