Export from Excel to Excel

JezLisle · #1 (**permalink**) 10-10-08, 07:48

I'm just thinking out loud, but is it possible to take data from a spreadsheet held in another folder and export certain ranges and paste into another spreadsheet?

I have been trying to look through the archives for information on this, does anyone have any ideas of how I can do this or know any threads I could read?

Thanks

shades · #2 (**permalink**) 10-14-08, 21:08

Yes. I assume you want to use VBA for this. Just be sure you know the path (and don't change it after setting up the code). Another way is to have the user open the file that you want to copy from/paste to.

JezLisle · #3 (**permalink**) 11-03-08, 04:03

I have used this code below which copies a range of data from one workbook to another, which works fine. I want to take this to another level. How can I copy data from a workbook to another workbook, but not knowing where the last row is

Code:

Sub copyDataToOtherWorkbook()
    Dim wbTo   As Workbook
    Dim wbFrom As Workbook

    Set wbFrom = ThisWorkbook
    Application.ScreenUpdating = False
    Set wbTo = Workbooks.Open("F:\DataDatabase.xls", False, False)
    With wbTo.Sheets("Database")
        .Range("Data").Value = wbFrom.Sheets("DataFrom").Range("DataPaste").Value
        .Close True
    End With
    MsgBox "All Data Updated"
    Application.ScreenUpdating = True
    Set wbTo = Nothing
    Set wbFrom = Nothing
End Sub

How can I do this?

Internet Services

Web Development

Digital Marketing

Consumer Tech