Copy and Paste from another Excel file

[siobeh]

Good day!,

I have two speadsheets, Source and Test1 file.


In Sourcefile, in 'Open Test1 and hold it' CommandButton, i just want to browse the Test1 file and be visible it' path in the textbox.
In the 2nd Commandbutton (still in source file), i just want to copy All the data except for the heading will be pasted to Test1 file. If the last row in Column 'A' in Test1 file was 'WK1' then the next will be 'WK1' and so forth.

I've attached the files.
Thanks in advance!

[ajryan88]

Hi,

A try these files and see if this is what you're after. If not, let me know and I can change what you need.

A couple of things to note:
1. I have assumed the path will not contain the file name "Test1.xlsx", nor will it include the "\" at the end of the path. If this is incorrect, let me know or feel free to change the code yourself if you are handy with VBA.
2. This assumes that once the data is copied to the source workbook, that you are finished with the test workbook, and Test1.xlsx is closed. Again, if this is incorrect, let me know or change it yourself.

Hope this helps

[siobeh]

Hi Aj, thanks for reply, I've tried the files that you've provided and there need somes modifications here:
1. When i click 'Open Test1 and Hold It', the user will browse where Test1.xlsx is and once the user have browsed the Test1.xlsx, it's path will be visible in the textbox. like: C:\My Documents\Test1.xlsx

[ajryan88]

No worries. Sorry about the misunderstanding

Try these attached files. Hope it's right this time.

Let me know

[siobeh]

Thanks AJ! the Commandbutton1 has now been worked!, Now, Commandbutton2 should be:

1.) Open the Excel file that has been browsed (Test1.xlsx)
2.) Copy the All the data of 'Source file' and add it in the last row of 'Test1.xlsx'
3.) If last row of Column 'A' was 'W1', then, next will be 'W2'. I've attached the final Output for your reference.

[ajryan88]

Hi,

Try this now...

[siobeh]

Youre a genius!! It works!, BTW, why is that the filename of the output file is in 'Binary'?

[ajryan88]

I'm not sure what you mean by the output file being in binary...can you please explain that a little further for me, perhaps with a screenshot if necessary?

You're very welcome. Please don't forget to mark this thread as solved and click on the star to leave me some positive reputation

[ajryan88]

Ah what a silly mistake. Here, try this one.

Also, please don't forget to mark this thread as solved and add some reputation to my post to say thanks

[siobeh]

Perfect!!! :D thank you so much Aj!!!!