Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-19-2010, 02:18 PM
cksm4 cksm4 is offline Application.FileSearch Windows XP Application.FileSearch Office 2007
Advanced Beginner
Application.FileSearch
 
Join Date: Aug 2010
Posts: 48
cksm4 is on a distinguished road
Default Application.FileSearch

A little new to Word so any help would be greatly appreciated. I believe that I need to replace Application.FileSearch with FileSystemObject to make my macro work in 2007. Below is the code causing the issue:

With Application.FileSearch
.NewSearch
.LookIn = MainPath


.SearchSubFolders = False
.FileName = DataName
.FileType = msoFileTypeAllFiles
If Not .Execute() > 0 Then 'if data file is not found
GoTo NoDataFile 'branches to label at the end of this procedure to open _
the Main Dialog box
End If
End With

Any ideas
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't set color in any Office application student25 Office 0 02-27-2010 02:12 PM
Application.FileSearch Best application to use? FrankW Office 2 06-13-2009 01:16 AM
What is Application Automation and How can I use it in VBA KramerJ Excel 0 03-30-2009 12:59 PM
Application.Caller pankajkankaria Excel 0 03-18-2009 11:48 AM
Application.FileSearch Run Outside application from toolbar button Richard Harison Word 3 12-20-2005 03:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft