Accessing a closed xls file from a macro

Hello,

An Excel macro which contains a few lines similar to following one is working if the file is currently open :

Please Login or Register  to view this content.

A macro which contains a few lines similar to following one is supposed to work when the file is closed :

Please Login or Register  to view this content.

but it does not ! I tried all syntax probabilities

Any suggestions ?

Thanks
Engin

Good afternoon Seapeace

...and welcome to the forum!!

Importing data from a closed workbook doesn't work like that.
One course of action is to turn off screen updating, open the workbook, copy the values to wherever, close the workbook and turn screenupdating back on.

Alternatively, you can use ADO to drag the data from the workbook whilst it's still closed. Have a look here for techniques on this :

http://www.erlandsendata.no/english/...dacimportwbado
http://www.erlandsendata.no/english/...nvbadacwbdbado
http://www.erlandsendata.no/english/...nvbadacwbdbdao

Also, next time you post, please try and remember to use code tags to wrap your code (use the # button at the top) - I've done it for you this time.

HTH

DominicB