Coping data without opening the document !!!!

[G21]

HI,
I just want to know the possibility to coping data from a XLS / CSV file without manually opening the document & close. Data will be pasted in to the active XLS sheet.

RGDS,
G

 

[jeffreybrown]

For copying data from a closed .xls workbook...try...

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

 

[G21]

HI jeffreybrown,
Thanks for the link ...

RGDS,
G

 

[jeffreybrown]

You're welcome

I use the GetData method for one of my project's and it works great.

Good Luck