Data from different workbook

M

michaelp1029

Board Regular
Joined
Jul 15, 2008
Messages
63
So here's what I am doing. I have a macro that opens an Open File Dialog Box. When I get to the file I need, I want to pull one of the worksheets from that file into the file I am currently in. But the file I want to pull data from will always have a different name so I am not sure exactly where to go from here. Help?

Danke
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
You must log in or register to reply here.

Similar threads

GMC The Macro Man
  • Solved
VBA Script - Return to named file
Replies
6
Views
124
mumps
mumps
R
  • Question
Is there a way to open a file that Power Query has locked as Read-Only?
Replies
0
Views
90
rcrumbliss
R
J
  • Question
Power Query - Data Refresh Error in Macro
Replies
3
Views
132
bobsan42
bobsan42
R
  • Question
VBA to pull data from closed workbooks
Replies
3
Views
487
Logit
Logit
K
  • Solved
Macro to match sheet reference in formula to workbook sheet
Replies
6
Views
165
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,214,833
Messages
6,121,857
Members
449,051
Latest member
excelquestion515

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top