Hi all,

Would to mod to code from Ron's website

http://www.rondebruin.nl/ado.htm#folder

Want to

1). Remove add a newsheet option
2). Change Range to Range("C12:C18,C20:C32,C34:C40,C42:C48")
3). Transpose the Data into a row

e.g Open work book 1 then

C12 value in A2 . Note Header in Row 1
C13 value in A3 etc

Any help would be apprecaited

Please Login or Register  to view this content.
Please Login or Register  to view this content.
Please Login or Register  to view this content.
VAB Noob