Import data from an excel workbook to another workbook without manually selecting

Hi all,

I'm trying to write a VBA code in my worksheet ( blank excel sheet) to pull data from another excel sheet without opening that file.

This code will open a new window to open my file and range. But, I'm trying to avoid the process of going through different windows to select my data.

I need this file to pull data from my C:\ directory with the range that I want. I use active X button for my convenience.

Please Login or Register  to view this content.

Yes, I want to pull it from Sheet1 in the Excel.xlsx Workbook

Thank you for this post. But, this still opens a message box for me to select the range and my destination. I want it to select certain range ex: A1:E10 and paste it automatically in my worksheet. So, basically all the message boxes should be automated.

Thank you so much It works!!