+ Reply to Thread
Results 1 to 8 of 8

How to Have Data that is caled from another work Book Permanate in the newly created Book

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    How to Have Data that is caled from another work Book Permanate in the newly created Book

    Greetings

    The following Code Creates a new work book and saves it. It saves the work book once all the Data has been entered.

    ***The Data comes from a master price list.***

    ***The Master price list is an excel sheet that is called via a Macro.***

    Please Login or Register  to view this content.
    However, all the Data (from the master price list), is deleted when I go to use or edit the new Book.

    How do I make the Data (from my master price list) more permanate in the newly saved book?

    Any help wouod be appreciated.
    Last edited by TBM; 06-24-2019 at 11:03 AM. Reason: Clarify My post

  2. #2
    Registered User
    Join Date
    06-23-2019
    Location
    United States
    MS-Off Ver
    Outlook
    Posts
    6

    Re: How to Have Data that is caled from another work Book Permanate in the newly created B

    The command xlsread() is very useful for reading excel files as long as the extension is an excel format. If it is in .csv then you can use csvread(). If you run into issues you may need to convert from binary to decimal, however I don't think it will be an issue. Once you have done the calculations/data manipulation you can use the command xlswrite() to write excel files. The excel files will save in the current directory unless you change it. Side note, in the command window type help xlswrite and help xlsread to understand the inputs required. Good luck

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Re: How to Have Data that is caled from another work Book Permanate in the newly created B

    My current code is a macro that automatically saves it as an "xlsm" file.

    Would I just change this macro to nw save it as an "xlswrite" file?

  4. #4
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Re: How to Have Data that is caled from another work Book Permanate in the newly created B

    as well, my master price list is another excell file

  5. #5
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Re: How to Have Data that is caled from another work Book Permanate in the newly created B

    I am uncertain how your post helps my situation. I edited my original post, In hopes that it may carify.

    Any help would be appreciated

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: How to Have Data that is caled from another work Book Permanate in the newly created B

    Hello TBM,

    You have copied 5 worksheets into a new workbook. Is one of these the master price list?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  7. #7
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Re: How to Have Data that is caled from another work Book Permanate in the newly created B

    No it does not. The master price list is separate.
    I need it to stay as a separate entity.

  8. #8
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: How to Have Data that is caled from another work Book Permanate in the newly created B

    Hello TBM,
    1. How is the data on the Master List arranged?
    2. Where does it start and where does it stop?
    3. Can you provide an example?

+ 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. [SOLVED] How To save entire book Within a newly created Folder
    By TBM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2018, 10:33 AM
  2. Current work book .xlsm convert to xlsx work book then mail
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-26-2016, 09:47 AM
  3. VBA Code for populating cells from one Work Book A to another Work Book with condition
    By ray.kanata in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-22-2015, 03:46 PM
  4. Work book link to other work book
    By Mjh35 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-08-2014, 03:55 AM
  5. Hyperlink within work book (without using book name)
    By raze in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2013, 12:49 AM
  6. Replies: 2
    Last Post: 06-20-2012, 05:10 AM
  7. [SOLVED] Reference user created work book later in code? GetSaveAsFilename
    By magicbob007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2012, 08:46 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