+ Reply to Thread
Results 1 to 2 of 2

Open a saved file, Insert New Sheet at beginning, and Paste Values from original file.

  1. 04-26-2018, 11:25 AM #1
    Mr.Bigz
    Mr.Bigz is offline
    Registered User
    Join Date
    02-24-2018
    Location
    Charlotte, NC
    MS-Off Ver
    2016
    Posts
    35

    Open a saved file, Insert New Sheet at beginning, and Paste Values from original file.

    I am trying to get the following macro to work but I'm not having any luck. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 04-26-2018, 11:44 AM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Open a saved file, Insert New Sheet at beginning, and Paste Values from original file.

    Maybe the clipboard is being lost:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Open file via VBA and paste filename in original file
    By kammend in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2016, 09:29 AM
  2. Delete a file that has just been saved and open original file or vice versa.
    By SHB19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2015, 07:48 AM
  3. Save sheet as CSV while keeping original file open?
    By gjwilson1216 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2014, 02:34 PM
  4. [SOLVED] VB to open a file, input on a file and close again, with NO macros/vb saved to file
    By unreal_event_horizon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2012, 11:41 AM
  5. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  6. Referencing original sheet to copy/paste into new sheet without using file name
    By pgarakani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2012, 02:06 PM
  7. Insert link to open file saved on Computer
    By infinitysales in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2009, 07:41 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1