Excel advertising its results

[Yarroll]

Hi,

How would an Excel workbook best advertise its presence and results?

I run a few macros on large collections of Excel files. It's often hundreds
of files. The majority of these files doesnt qualify for further attention,
but some do. Lets say that interesting files return "1" in range("A1"), it
doesnt make sense to open all the files to have a look at A1. So how do I
distinguish the interesting ones without opening them? I was thinking of a
macro to - if A1=1 - save a workbook to some specific folder. Or saving it
with a filename preceded by "Look here-."

Sure, there's many ways to skin a cat and lots depends on eg. proportion of
interesting files to useless files, but how would you go about this? Any
ideas?

TIA. Best regards, Yarroll

 

[JE McGimpsey]

Changeing filename would probably be easiest, but look here:

http://j-walk.com/ss/excel/tips/tip82.htm

or, for a modified version that works cross-platform:

http://www.mcgimpsey.com/macoffice/excel/getcellvalue.html

 

[Yarroll]

"JE McGimpsey"

Changeing filename would probably be easiest, but look here:

http://j-walk.com/ss/excel/tips/tip82.htm

or, for a modified version that works cross-platform:

http://www.mcgimpsey.com/macoffice/excel/getcellvalue.html

Thank you. That's really interesting. Any idea how to circulate through all
the 'f'-s (one variable listed in the macro) in a folder? (Macro below) and
record them in Cells(r,c) rather than values from 99Budget.xls?

Thanks. Best regards, Yarroll

Sub TestGetValue2()
p = "c:\XLFiles\Budget"
f = "99Budget.xls"
s = "Sheet1"
Application.ScreenUpdating = False
For r = 1 To 100
For c = 1 To 12
a = Cells(r, c).Address
Cells(r, c) = GetValue(p, f, s, a)
Next c
Next r
Application.ScreenUpdating = True
End Sub

 

[JE McGimpsey]

For all files in a folder, there are a number of ways - search the
archives at

http://groups.google.com/advanced_group_search?q=group:*excel*