macro to select path to collect data from

[clixo]

Hi , i have a macro , done with the help of this forum that colects data from seeveral files in one folder that is hard coded in the macro, what i would like now is to have the possibility to select the working folder to work
attatched the files i have now

The macro i have is

Please Login or Register  to view this content.

[Domski]

You can use this code to prompt someone to select a folder:

Please Login or Register  to view this content.

Dom

[clixo]

Thanks Dom, but how can i join the code you sent to my macro ? ... i am really a noob in vba .....

[Domski]

Not tested but think this should do it:

Please Login or Register  to view this content.

Dom

[clixo]

Thanks Dom , i tested and it did not worked... seams not be opening the folder i choose.

[Domski]

Small but important correction to this line:

Please Login or Register  to view this content.

Dom

[clixo]

Hi again .. its almost there , the sub folders are not stored in the path, i. e if i select c:\2010\test\*.xls, the macro gets c:\2010\*.xls .

[Domski]

It should either select the displayed folder or if you highlight one include that.

Noticed this will need changing as well though:

Please Login or Register  to view this content.

Dom

[clixo]

Now it works !!!
Thanks !

[clixo]

this is how it looks at the end :

Please Login or Register  to view this content.