Macro to copy from one workbook to a different workbook

**MsMikkiC** · 05-19-2014, 09:40 AM

I need to copy data from one workbook to another workbook. The problem is that the receiving workbook will always have a different name. Here is my macro:

Sub Add_Units_Worksheet()
'
' Add_Units_Worksheet Macro
'
    Sheets.Add After:=Sheets(Sheets.Count)
    Sheets("Sheet2").Select
    Sheets("Sheet2").Name = "Units"
    Windows("Test File.xls").Activate
    Range("A1").Select
    ActiveSheet.Paste
    Cells.Select
    Cells.EntireColumn.AutoFit
    Range("A1").Select

End Sub

I need the line Windows("Test File.xls").Activate to allow the user to choose the file to be activated, preferably without having to type in a file name. This file will already be open.

Any help anyone can provide would be much appreciated.

Thanks.
Mikki

**bluesurger** · 05-19-2014, 09:44 AM

http://www.excelforum.com/excel-prog...o-another.html

maybe this is some information for you:

**MsMikkiC** · 05-20-2014, 08:50 AM

I apologize. I haven't had the time to test this solution to see if it works. I till try to test it tonight and will respond as soon as I have the chance.

Thank you for your response. I appreciate your time.

**MsMikkiC** · 05-28-2014, 04:01 PM

I've looked at the code in the post you referenced, but I have not been able to figure out how to make it work in my situation.

I've done some reading and have figured out that I should be able to retrieve the data from the source workbook without actually opening it if I use the entire file path. I'm hoping that would solve the problem of having to reactivate the "Test" file. However, I'm too inexperience with VBA to know the syntax necessary to accomplish this. I need to include the name of the worksheet in the source workbook as well as the file path.

I would greatly appreciate any help.

Thank you.
Mikki

Macro to copy from one workbook to a different workbook

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro to copy from one workbook to a different workbook

Re: Macro to copy from one workbook to a different workbook

Re: Macro to copy from one workbook to a different workbook

Re: Macro to copy from one workbook to a different workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to find data in source workbook and copy paste to target workbook

Run Macro in closed workbook and copy specific coloumn in active workbook

Save Copy of Macro Workbook as new Workbook with only Worksheets and values, Same Location

Macro to copy first sheet from other non opened workbook - let user choose which workbook

Macro to copy data from other workbook - let user choose which open workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions