|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 4th, 2009, 12:45 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2002 to 2007 Macro containing "Filesearch"
I have a macro running on a PC with the Excel version 2002.
This macro use the Filesearch and it's not recognize in a other PC running with Excel 2007 By open the Object Browser under Classes, I can see this "Filesearch", but in light ! How could I have it in bold (mean recognize ??) Thank's for your help 
|
|
#2
December 4th, 2009, 01:48 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2002 to 2007 Macro containing "Filesearch"
Filesearch was removed in xl2007.
You'll have to find another way--maybe using Dir or FileSystemObject? dede wrote: I have a macro running on a PC with the Excel version 2002. This macro use the Filesearch and it's not recognize in a other PC running with Excel 2007 By open the Object Browser under Classes, I can see this "Filesearch", but in light ! How could I have it in bold (mean recognize ??) Thank's for your help -- Dave Peterson
|
|
#3
December 4th, 2009, 02:56 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2002 to 2007 Macro containing "Filesearch"
So why could you still see it in the Object Browser & as well in the help
with the example how to use it ?? With Application.FileSearch .NewSearch .LookIn = "C:\My Documents" .SearchSubFolders = True .FileName = "Run" .MatchTextExactly = True .FileType = msoFileTypeAllFiles End With "Dave Peterson" wrote: Filesearch was removed in xl2007. You'll have to find another way--maybe using Dir or FileSystemObject? dede wrote: I have a macro running on a PC with the Excel version 2002. This macro use the Filesearch and it's not recognize in a other PC running with Excel 2007 By open the Object Browser under Classes, I can see this "Filesearch", but in light ! How could I have it in bold (mean recognize ??) Thank's for your help -- Dave Peterson .
|
|
#4
December 4th, 2009, 05:00 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2002 to 2007 Macro containing "Filesearch"
If that's true (I didn't check), then I'd say Microsoft made a mistake.
dede wrote: So why could you still see it in the Object Browser & as well in the help with the example how to use it ?? With Application.FileSearch .NewSearch .LookIn = "C:\My Documents" .SearchSubFolders = True .FileName = "Run" .MatchTextExactly = True .FileType = msoFileTypeAllFiles End With "Dave Peterson" wrote: Filesearch was removed in xl2007. You'll have to find another way--maybe using Dir or FileSystemObject? dede wrote: I have a macro running on a PC with the Excel version 2002. This macro use the Filesearch and it's not recognize in a other PC running with Excel 2007 By open the Object Browser under Classes, I can see this "Filesearch", but in light ! How could I have it in bold (mean recognize ??) Thank's for your help -- Dave Peterson . -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
