Hi Shoodie,
Do you still need help with this?
There are several ways to find the files you need to edit, depending on your
target Excel versions, platforms (mac/windows), and security settings on the
target operating system.
Perhaps the most cumbersome of the available methods is the Dir command
(along with GetAttr depending on your implementation), but the advantage to
using this command to find your files is that it is available in all Excel
versions and on all platforms. The other two most accessible methods are to
use the Scripting.FileSystemObject (which is part of VBScript - windows only
and some environments have it disabled for security reasons), and the
FileSearch object which was once part of VBA. FileSearch was brilliantly
simple but was removed after Excel 2003. I know Dir and the other current
file commands and functions don't support Unicode in file or folder names.
I am not sure about the other methods. It is possible to achieve Unicode
support on Windows using the Windows API (I have code I can share for that).
To search all subfolders with Dir or Scripting.FileSystemObject your search
procedure can be recursive (call itself).e.g.:
Sub ModifyFilesInFolder(Path As String)
For each file.
ModifyFile (file) ' sub to modify a file, or include the code here
Next
For each folder
ModifyFilesInFolder(folder) ' recursive
Next
End Sub
I can help you with the details if required.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shoodie
Sent: Wednesday, June 06, 2012 6:17 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Updating multiple excel workbooks
Hi all
I need a way to replace the contents of a particular cell (C8) of an Excel
sheet to a specific value. I need to be able to run this macro so that it
applies it to all the excel workbooks in a given folder and all its
subfolders.
Any ideas?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
