+ Reply to Thread
Results 1 to 7 of 7

How do i save a shet independently from the excel book

  1. #1
    Registered User
    Join Date
    12-31-2015
    Location
    peru
    MS-Off Ver
    2007
    Posts
    4

    Lightbulb How do i save a shet independently from the excel book

    Hello, im having an issue with a inventory book that ive created, basically i have 2 sheets, one of them its the inventory one that gets updated wen i get a sale on the second sheet (the sales one), but now the problem is that i want to be able to save the data adquired from the formulas in the first sheet (the inventory one) while deleting the information of the second sheet (the sales one).
    Ill add the link of the excel book, please help.

    http://imgur.com/a/4oewA
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: How do i save a shet independently from the excel book

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 12-31-2015 at 03:29 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    12-31-2015
    Location
    peru
    MS-Off Ver
    2007
    Posts
    4

    Re: How do i save a shet independently from the excel book

    Hi, and thank you in advance for the help, i was wondering if theres any problem if i try to run the macro in a excel document that its in spanish, ive been trying to run it but i get "error in the compilation Sub or Function has not been defined", im guessing its because of the language difference.
    Happy new year! Ty for the aid.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,812

    Re: How do i save a shet independently from the excel book

    I don't know VBA but I don't think the language has anything to do with it. Looks like a typo. Perhaps ( just guessing, don't throw stones at me)


    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: How do i save a shet independently from the excel book

    my Apologies try this:

    Sub Macro3()

    [CODE]MYPATH = ActiveWorkbook.Path
    Sheets("sales").Copy
    ChDir MYPATH
    ActiveWorkbook.SaveAs Filename:= _
    MYPATH & "\Sale " & Replace(Date, "/", "-") & ".xls.xlsx", FileFormat:= _
    xlOpenXMLWorkbook, CreateBackup:=False
    ActiveWindow.close
    End Sub[/CODE.
    Last edited by mehmetcik; 12-31-2015 at 03:33 PM.

  6. #6
    Registered User
    Join Date
    12-31-2015
    Location
    peru
    MS-Off Ver
    2007
    Posts
    4

    Re: How do i save a shet independently from the excel book

    Mehmetcik, i wasnt able to use the second command either, but the one that Pepe shared was succesfull, thank you any way , now, the thing is even tho im able to save the inventory sheet independently from the book (wich is great) im not able to reopen the sales sheet on the same file and make them work together, im guessing that the formula that was linking them together got broken, if you have any suggestion please drop them, thank you in advance, youre both very kind and i hope you have a happy new year :D!

  7. #7
    Registered User
    Join Date
    12-31-2015
    Location
    peru
    MS-Off Ver
    2007
    Posts
    4

    Re: How do i save a shet independently from the excel book

    Still trying to figure out how to save the values of the inventory sheet independently from the sales one, and then re-link them to be able to keep on updating the inventory stock :S, please help, ty in advance.

+ 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] can 2 excel instances act independently?
    By rampal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2015, 12:31 PM
  2. Save one sheet, and save work book as back up
    By ryanlee84 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2014, 03:58 AM
  3. [SOLVED] Excel 2007 : How to save just one sheet from an excel wok book
    By stojko89 in forum Excel General
    Replies: 2
    Last Post: 05-15-2013, 09:55 AM
  4. How to make a new excel shet using macros
    By Bhavani in forum Excel General
    Replies: 1
    Last Post: 01-06-2012, 10:13 PM
  5. [SOLVED] Excel should treat windows independently like Word.
    By FocusCS in forum Excel General
    Replies: 0
    Last Post: 03-30-2006, 07:35 PM
  6. Save Excel book as Html Page Using Macro
    By Excel in forum Excel General
    Replies: 3
    Last Post: 02-21-2006, 10:10 AM
  7. Save Excel book as Html Page Using Macro
    By bj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2006, 07:10 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