Results 1 to 2 of 2

VBA Code to export or import between fixed named workbook and variable name workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2018
    Location
    Tampa, Florida
    MS-Off Ver
    365
    Posts
    105

    VBA Code to export or import between fixed named workbook and variable name workbook

    I have a workbook (fixed name) that I want to import or export data to specific cells from specific cells of another workbook. The second workbook is the data source file. It's name is descriptive name changes constantly. I was hoping I could use VBA code to import or export, depending on the best location for the macro.

    I have attached simplified workbooks for reference. Desire is to select specific cells from AlwaysDifferentName.xlsx and copy to specific cells in AlwaysSameName.xlsx.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to export/import VBA code from one workbook to another?
    By jGKpZ8a33sPrnqX8fam7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2017, 01:26 PM
  2. Export Name Manager from one excel workbook and import to another
    By davisfs2007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-27-2016, 12:06 AM
  3. 'Multiple Code Module Management' (Export, Import, CleanUp, etc.)
    By Warbe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2015, 06:17 PM
  4. Replies: 0
    Last Post: 03-27-2014, 12:38 PM
  5. Replies: 4
    Last Post: 03-06-2014, 07:49 PM
  6. [SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.
    By paullie1912 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2014, 02:38 AM
  7. Code to reference variable named workbook?
    By ajava in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2009, 08:22 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