Hello everybody
Tried on the pre defined solutions on the net but did not match.
In my excel file in sheet9 the first row is my own defined headers.
The output of the code will be from second row onwards.
On a command button click I want to open normal browse screen.
I will go in a particular drive in the required folder and pressing ctrl
key will select one or more than one excel files ( can be .xls or .xlsx or .xlsm ) and
give ok or open.
Why need browse screen because, evertime the target folder changes.
Imp:
Every file in the folder has a different header name in A1. Not to consider the names.
Every file in the folder has data in Sheet1 in column A and from A2 onwards, but since
all the Sheet1 has been differently renamed , kindly not consider the renamed sheet name
while defining the code. In code use Sheet1.
As I give open or ok, two things the code has to do.
1) Read the file names i.e before extension name and place all the names from column A to Z or
whatever but from second row.
2) Every file have values listed through out the column from
A2 onwards ( in the column there can be many cells in between that are blank ). Values
will be listed down from these file to sheet9 below the respective file names.
Thanks
TG999
Tried on the pre defined solutions on the net but did not match.
In my excel file in sheet9 the first row is my own defined headers.
The output of the code will be from second row onwards.
On a command button click I want to open normal browse screen.
I will go in a particular drive in the required folder and pressing ctrl
key will select one or more than one excel files ( can be .xls or .xlsx or .xlsm ) and
give ok or open.
Why need browse screen because, evertime the target folder changes.
Imp:
Every file in the folder has a different header name in A1. Not to consider the names.
Every file in the folder has data in Sheet1 in column A and from A2 onwards, but since
all the Sheet1 has been differently renamed , kindly not consider the renamed sheet name
while defining the code. In code use Sheet1.
As I give open or ok, two things the code has to do.
1) Read the file names i.e before extension name and place all the names from column A to Z or
whatever but from second row.
2) Every file have values listed through out the column from
A2 onwards ( in the column there can be many cells in between that are blank ). Values
will be listed down from these file to sheet9 below the respective file names.
Thanks
TG999