Excel VB to get data, move files until directory is empty 1

[NWildblood]

Hi
This is an almost identical request to this 2007 thread, which unfortunately doesn't have enough detail in the responses for me.

http://www.tek-tips.com/viewthread.cfm?qid=1422496

I need to write a macro that copies information from a number of spreadsheets in one folder and appends the information in a spreadsheet in a different folder. The file names are varied and the number of spreadsheets will change each time this is run. Once the information is copied from each spreadsheet I need to move the file and continue until all files have been moved.

I only have to write VB on an ad-hoc basis, and despite looking through Tek-Tips haven't seen this elsewhere; apologies if duplicating a thread.

Thanks in advance.



"No-one got everything done by Friday except Robinson Crusoe...

 

[SkipVought]

Hi,

Do you have any code written? Where are you stuck?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[NWildblood]

Hi Skip
Thanks, I'm still at pseudo code. I know I can manage all the get-data bit(and loop it), its the actual moving of a file to a different folder after collecting its data, that I can't get get started with. (And also running the code until there are no files left in the folder.)

Sorry if this is too nebulous... Thanks again.



"No-one got everything done by Friday except Robinson Crusoe...

 

[SkipVought]

Then check out the VBA Name statement in HELP.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[NWildblood]

Skip, that's right on the money, thanks.

"No-one got everything done by Friday except Robinson Crusoe...