Importing Excel spreadsheet data into another Excel spreadsheet containing VBA

by

This should get you started:
Using VBA in your own Excel workbook, have it prompt the user for the filename of their data file,
then just copy that fixed range into your target workbook (that could be either the same workbook as your macro enabled one, or a third workbook).
Here’s a quick vba example of how that works:

' Get customer workbook...
Dim customerBook As Workbook
Dim filter As String
Dim caption As String
Dim customerFilename As String
Dim customerWorkbook As Workbook
Dim targetWorkbook As Workbook

' make weak assumption that active workbook is the target
Set targetWorkbook = Application.ActiveWorkbook

' get the customer workbook
filter = "Text files (*.xlsx),*.xlsx"
caption = "Please Select an input file "
customerFilename = Application.GetOpenFilename(filter, , caption)

Set customerWorkbook = Application.Workbooks.Open(customerFilename)

' assume range is A1 - C10 in sheet1
' copy data from customer to target workbook
Dim targetSheet As Worksheet
Set targetSheet = targetWorkbook.Worksheets(1)
Dim sourceSheet As Worksheet
Set sourceSheet = customerWorkbook.Worksheets(1)

targetSheet.Range("A1", "C10").Value = sourceSheet.Range("A1", "C10").Value

' Close customer workbook
customerWorkbook.Close

More Related Contents:

  1. Format Cell Contents
  2. Excel formula checklist in employees
  3. How do I put double quotes in a string in vba?
  4. Excel VBA – How to add dynamic array formula
  5. Stop Excel from automatically converting certain text values to dates
  6. How can I URL encode a string in Excel VBA?
  7. Compare double in VBA precision problem
  8. Row count on the Filtered data
  9. VBA – Write all possible combinations of 4 columns of data [duplicate]
  10. Remove duplicates from array using VBA
  11. 2 ways for “ClearContents” on VBA Excel, but 1 work fine. Why? [duplicate]
  12. How to automatically insert a blank row after a group of data
  13. Get File Path (ends with folder)
  14. Get length of array?
  15. Email a single attachment from folder of files each to a different person
  16. Bad data selection using VBScript , on date field values
  17. Excel error 1004 “Unable to get …. property of WorksheetFunction class” appearing inconsistently
  18. Sending object array to variant works before August 2019 Windows update, but fails after update
  19. Find last row in range
  20. How can I install/use “Scripting.FileSystemObject” in Excel 2010 for MAC?
  21. Differences between Excel’s Form Controls & ActiveX Controls
  22. Excel VBA User Defined Function that counts cells with conditional formatting
  23. How to add an attachment to an email using VBA in Excel
  24. Get Timezone Information in VBA (Excel)
  25. Excel is calculating a formula with a VBA function as an error unless it is re-entered
  26. Excel VBA Run-time error ’13’ Type mismatch
  27. ThisWorkbook.FullName returns a URL after syncing with OneDrive. I want the file path on disk
  28. How to query a MS-Access Table from MS-Excel (2010) using VBA
  29. How to roundup a number to the closest ten?
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment