Get data from Closed workbook and paste in current Workbook

[rizmomin]

Hello:

I have closed workbook with some data.
The name of the sheet where the data is will be the same as name of the closed workbook.
Example : Name of the closed workbook is Store1Data.xls
Then, the name of the sheet in closed workbook where the data is will be "Store1Data"

I need VB Code to copy closed worklook data in Sheet "ImportData" of the current workbook.

Name and Location of the closed upbook will be in Cell S3 of the current workbook.

Please let me know if you have any questions.
Thanks.

RM

[Mumps1]

Hi RM. Place this macro in a regular module in your current workbook and run it from there:

Please Login or Register  to view this content.

You didn't specify exactly what data you wanted to copy so this macro copies all the data in the sheet.

[rizmomin]

Hi Mumps1:

Seems to work to the point that the closed file will open and it will give error at

Please Login or Register  to view this content.

I have added The sheet name in current workbook at cell T2
and now i have changed above line to

Please Login or Register  to view this content.

Still does not copy and close

Please have a look and let me know.
Thanks
RM

[rizmomin]

Hi Mumps1:

Seems to work to the point that the closed file will open and it will give error at

Please Login or Register  to view this content.

I have added The sheet name in current workbook at cell T2
and now i have changed above line to

Please Login or Register  to view this content.

Still does not copy and close

Please have a look and let me know.
Thanks
RM

[ihmha]

I use this all the time to get the data from a closed file

Please Login or Register  to view this content.

[Mumps1]

When I tried the code I posted in Post#2 on some dummy data and workbooks, it worked properly. It would be easier to test if I could see your actual files. Could you post a copy of each file?

[rizmomin]

Hi Mumps1:

I got it fugre out, I think, I will test further and let you know if any problem.
Thanks a lot for great hep.
RM

[Mumps1]

Glad to help.