hi
see this site
http://www.rondebruin.nl/ado.htm

regards
FSt1

"Kashyap" wrote:

Hi, as of now I am using formulas to get data from closed files. I was
looking if I can get data from a closed file with that help of macro?

Source file R3:R15
Destination file C3:O3 (Transpose)