teodormircea
02-27-2008, 05:04 AM
Hello everyone i need a little help for a macros that does the fololowing things
I would like from an exceel sheet open a browser file , search for an excel file or workbook and then, display in a listox the information about this excel file or workbook (the list of sheets and the colomns that contains everyone (i think headers it will be better).Then chose a sheet, columns of this sheet and copy them in the workbook that contain the macros, in the sheet that i have to chose , and the place that i have to chose(it can be used a cell like reference, because i can copy several columns from other filles in the same sheet but different place).
And all this with a macros :banghead:
Thnaks for your help guys
I would like from an exceel sheet open a browser file , search for an excel file or workbook and then, display in a listox the information about this excel file or workbook (the list of sheets and the colomns that contains everyone (i think headers it will be better).Then chose a sheet, columns of this sheet and copy them in the workbook that contain the macros, in the sheet that i have to chose , and the place that i have to chose(it can be used a cell like reference, because i can copy several columns from other filles in the same sheet but different place).
And all this with a macros :banghead:
Thnaks for your help guys