M
Melwin
Want to consolidate data from many flies which are in the same format to a
sigle file how can i do it in the best way?
sigle file how can i do it in the best way?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
You can use a DIR looping macro to open or create formulas for each workbook
desired to the next available row on the destination file.
desired to the next available row on the destination file.
M
Melwin
Thanks for the update but am not so good with xl can you give me a step by
step plan or some link where i can find the same
step plan or some link where i can find the same
R
Ron de Bruin
Start here Melwin
http://www.rondebruin.nl/copy3.htm
If you need more help post back and I try to help you tomorrow
http://www.rondebruin.nl/copy3.htm
If you need more help post back and I try to help you tomorrow
D
Don Guillett
Here is the basic idea for using DIR
Sub FindFilesToChangeSAS()' Bare bones version to test for DIR
Dim FN As String
FN = Dir(ThisWorkbook.Path & "\*.*")
Do Until FN = ""
MsgBox FN 'Name of each file in the directory(folder) displayed
'Do what is desired with the workbook
Loop
End Sub
Sub FindFilesToChangeSAS()' Bare bones version to test for DIR
Dim FN As String
FN = Dir(ThisWorkbook.Path & "\*.*")
Do Until FN = ""
MsgBox FN 'Name of each file in the directory(folder) displayed
'Do what is desired with the workbook
Loop
End Sub