Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Below is a snippet of code I am using to import sheets into another
workbook. It works just fine on most computers, but on one when it gets to the last line (I posted) it then goes to the End Sub. All of the computers are running Excel 2002 or above. It doesn't seem to find any files in the specified folder and there are several there. Can anyone shed some light? Thanks, Phil With Application.FileSearch .NewSearch .LookIn = "C:\NCAA\Returned Brackets" .SearchSubFolders = False .Filename = "*.xls" If .Execute() 0 Then |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Button to execute Add-in | Excel Discussion (Misc queries) | |||
concatenate and then execute? | Excel Worksheet Functions | |||
Could not execute | Excel Worksheet Functions | |||
VBA new function doesn't execute | Excel Programming | |||
tried to execute application from VBA | Excel Programming |