Hi

I Have a macro that pulls data in from another excel file, problem is it asks me to select the table. how can i program it so the user doesn't need to select anything. there is only 1 table in the file. this is the current code

Please Login or Register  to view this content.
any help would be much appreciated.

Thanks,

Chris