Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 4th 09, 12:45 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 8
Default 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   Report Post  
Old December 4th 09, 01:48 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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   Report Post  
Old December 4th 09, 02:56 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 8
Default 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   Report Post  
Old December 4th 09, 05:00 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 ronhansen Excel Discussion (Misc queries) 1 November 15th 09 09:33 PM
2007 Need macro to auto set option buttons all to "Yes" or "No" Paula Excel Worksheet Functions 1 October 20th 09 08:07 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
how i convert "100" to "hundred"( number to text) in excel-2007 mohanraj Excel Worksheet Functions 1 May 11th 08 09:07 PM
calling "Fact()" from a macro in excel 2002 Joe Farruggio Excel Worksheet Functions 1 December 3rd 06 10:58 PM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017