+ Reply to Thread
Results 1 to 2 of 2

Simple script to import values from another workbook?

Hybrid View

vonsworld Simple script to import... 02-27-2020, 11:35 AM
gue2013 Re: Simple script to import... 02-27-2020, 12:22 PM
  1. #1
    Registered User
    Join Date
    02-18-2020
    Location
    London
    MS-Off Ver
    2021
    Posts
    79

    Simple script to import values from another workbook?

    Hello
    Please could someone help by giving me a vba script to import some values from one workbook to another.

    For example, if I'd like to import cell A1 in source.xls/sheet1 to cell B1 in dest.xls/sheet2, what would be a suitable script please?

    Thank you, this will save me a lot of time figuring it out on my own
    Robin

  2. #2
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Simple script to import values from another workbook?

    in the developers tab you will find "Record Macro". Start recording and open source.xls. Select A1 in sheet 1 and copy the cell to wherever you need it. stop recording. Now you have your macro

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. import values from named range in another workbook
    By batchjb69 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2016, 05:48 PM
  2. [SOLVED] Import data to workbook - Paste values
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2015, 08:03 AM
  3. [SOLVED] VBA Macro adding together certain numeric values during import to new workbook
    By PatRiot199 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2014, 04:02 AM
  4. Implementing TextFile import Delimiter settings on TXT Import VBA Script
    By Canuckle777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2013, 02:06 PM
  5. simple If script
    By admiralpumpkin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-15-2011, 12:06 PM
  6. Simple Import Data From Another WorkBook
    By somebody113 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-07-2011, 04:29 PM
  7. [SOLVED] Can you import values from one workbook to another?
    By Phantom1219 in forum Excel General
    Replies: 2
    Last Post: 03-16-2006, 08:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1