Copy data from closed book

Hi All,

I want to copy the data from closed workbook which varies path everytime and paste in other workbook by using dilogue box option to open the closed workbook.

Please any one can assist me.

Thank you in advance.

Hi, cbachu1,

if you want to open the workbook change directory and folder if you know where itīs located and then maybe use GetOpenFilename or Application.Dialogs(xlDialogOpen).Show. Mind the difference: the first delivers path and name to a variable while the second opens the workbook.

If you want to copy from a closed workbook have a look at Copy a range from closed workbook (Local, Network and on the internet).

And could you please give a bit more details on

... paste in other workbook

Ciao,
Holger

I want to copy the date from chandu workbook from range A10:C40 and paste it in other workb book

I am using the Application.GetOpenFilename script to select the file. once i open that file i need to copy the date from the A10:C40 and paste it othe workbook.

It would be appreciated if you can resolve my issue
thank you in advance.

Hi, cbachu1,

the range from the opened workbook active sheet A10:C40 is copied to the workbook containing the macro, aqctiive sheet, added underneath in Column A, thereafter the opened workbook is closed without saving:

Please Login or Register  to view this content.

Letīs see what amendments need to be taken.

Ciao,
Holger

Thank you very much for your responce.

Can you please let me the ways to learn macro's

Do you know any institute which can train to learn macro's

If you have any material can you please share

Thank you in advance.

Hi, cbachu1,

please have a look at New to Excel Programming and looking for learning materials where youīll find some tips on what and where to find materials on this topic.

Ciao,
Holger