Macro to Copy and Paste the data

[VARGEESH]

Hi,


I have an excel file name as "Format" in which "Sheet1" has a command button.


When i click the command button it should open the Open dialog box using the below code:

Application.GetOpenFilename("excel(*.xls), (*.xls)")

Then I will select an excel file and it should copy the data of the selected file and should paste it in "Sheet2" of "Format" workbook.


And then the selected file should close simultaneously.


Can you please advice me.


Thank you,

Vargeesh

 

[SirJB7]

Hi, VARGEESH!

Give a look at this file:

https://dl.dropbox.com/u/60558749/Macro%20to%20Copy%20and%20Paste%20the%20data%20%28for%20VARGEESH%20at%20chandoo.org%29.xlsm

Just advise if any issue.

Regards!

 

[VARGEESH]

Thank you so much SirJB7.


It's working.


In addition to that i want to include the below code also.


http://www.2shared.com/document/De048EOU/finalformatting.html


Please advice me.


Thanks!

 

[SirJB7]

Hi, Vargeesh!

Tried adding that code to my uploaded file?

If not, you should have done it, otherwise it'd be very difficult for you to handle future updates, IMHO.

If not and at your own risk, I added your code to a module and added the sentence to call it at the end of my code. But I haven't neither read nor checked what it should do, I only compiled to confirm no errors present.

Please download again the file from same previous link.

Regards!