I tried searching here for an answer to this problem, but didn't find what
seemed like an appropriate solution... (Unless I am looking at it wrong...)
I have a folder with over 360 files I need to copy A to C and colums AE, AG,
AI and AK if data is present in these colums I would like to append that
data to another workbook in cells A - G (I think those column counts
match...)
I have tried several attempts at a macro to do this, but think VBA from the
file I am filling with data is my best bet. Is there an example of this out
there?
I will keep plugging away at this, and will post any resuts here to this
group.

Thanks for any help that you can offer! Jason

Sorry for the typo in the previous header! My fingers aren't nearly as fast
as my brain...

I have written the code to cycle through all of the files in the folder
(attached below) I think that I can copy the ranges that I want, but...
(there is always a but) I cannot find the last row of data (it will be
different in each workbook.

Jason

For intYear = 2006 To 2007

For intMonth = 1 To 12

For intDay = 1
To 31
strFileName
= intYear & " " & Format(intMonth, "00") & " " & Format(intDay, "00") _
& "
0000 (Wide).dbf"

With
Application.FileSearch

.LookIn = strDirectoryPointer

.Filename = strFileName
If
..Execute > 0 Then
'
enter code here to copy and paste desired cells into working file
'
This is Extra from cut and paste...
MsgBox
"There were " & .FoundFiles.Count & _
"
file(s) found."

For i
= 1 To .FoundFiles.Count
MsgBox
..FoundFiles(i)

Next i
Else
MsgBox
"There were no files found."


End If
End
With
Next intDay

Next intMonth

Next intYear


"Jasonm" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I tried searching here for an answer to this problem, but didn't find what
>seemed like an appropriate solution... (Unless I am looking at it wrong...)
> I have a folder with over 360 files I need to copy A to C and colums AE,
> AG, AI and AK if data is present in these colums I would like to append
> that data to another workbook in cells A - G (I think those column counts
> match...)
> I have tried several attempts at a macro to do this, but think VBA from
> the file I am filling with data is my best bet. Is there an example of
> this out there?
> I will keep plugging away at this, and will post any resuts here to this
> group.
>
> Thanks for any help that you can offer! Jason
>

Ron Debruin has about every type of copy macro there is. Check his site out:

http://www.rondebruin.nl/tips.htm

"Jasonm" wrote:

> I tried searching here for an answer to this problem, but didn't find what
> seemed like an appropriate solution... (Unless I am looking at it wrong...)
> I have a folder with over 360 files I need to copy A to C and colums AE, AG,
> AI and AK if data is present in these colums I would like to append that
> data to another workbook in cells A - G (I think those column counts
> match...)
> I have tried several attempts at a macro to do this, but think VBA from the
> file I am filling with data is my best bet. Is there an example of this out
> there?
> I will keep plugging away at this, and will post any resuts here to this
> group.
>
> Thanks for any help that you can offer! Jason
>
>
>

Thanks, I'll give him a look!

Jm

"JLGWhiz" <(E-Mail Removed)> wrote in message
news:A12084A3-F461-4143-BEA3-(E-Mail Removed)...
> Ron Debruin has about every type of copy macro there is. Check his site
> out:
>
> http://www.rondebruin.nl/tips.htm
>
> "Jasonm" wrote:
>
>> I tried searching here for an answer to this problem, but didn't find
>> what
>> seemed like an appropriate solution... (Unless I am looking at it
>> wrong...)
>> I have a folder with over 360 files I need to copy A to C and colums AE,
>> AG,
>> AI and AK if data is present in these colums I would like to append that
>> data to another workbook in cells A - G (I think those column counts
>> match...)
>> I have tried several attempts at a macro to do this, but think VBA from
>> the
>> file I am filling with data is my best bet. Is there an example of this
>> out
>> there?
>> I will keep plugging away at this, and will post any resuts here to this
>> group.
>>
>> Thanks for any help that you can offer! Jason
>>
>>
>>

Thanks again, he did have just teh thing. Unfortunately I had too much data
to fit excel... I'll have to move to access.

Thanks again,

Jm

"JLGWhiz" <(E-Mail Removed)> wrote in message
news:A12084A3-F461-4143-BEA3-(E-Mail Removed)...
> Ron Debruin has about every type of copy macro there is. Check his site
> out:
>
> http://www.rondebruin.nl/tips.htm
>
> "Jasonm" wrote:
>
>> I tried searching here for an answer to this problem, but didn't find
>> what
>> seemed like an appropriate solution... (Unless I am looking at it
>> wrong...)
>> I have a folder with over 360 files I need to copy A to C and colums AE,
>> AG,
>> AI and AK if data is present in these colums I would like to append that
>> data to another workbook in cells A - G (I think those column counts
>> match...)
>> I have tried several attempts at a macro to do this, but think VBA from
>> the
>> file I am filling with data is my best bet. Is there an example of this
>> out
>> there?
>> I will keep plugging away at this, and will post any resuts here to this
>> group.
>>
>> Thanks for any help that you can offer! Jason
>>
>>
>>