+ Reply to Thread
Results 1 to 6 of 6

need to save sheet as a copy every time sheet is up dated

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    need to save sheet as a copy every time sheet is up dated

    in the below sample i need a macro that will save the sheet as a copy every time it updates. I need it to save as the info in cell D1, and to a specific file. I currently have it saving everytime it updates but not as a copy, and this is causing me issues.

    Batch choochoo.xls

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,249

    Re: need to save sheet as a copy every time sheet is up dated

    When I try to download and open your file, Excel tells me it is in an unrecognizable format. Please make sure that you have uploaded a true Excel file that is not corrupted.
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: need to save sheet as a copy every time sheet is up dated

    hmmm let me try this one

    Picking log-Rev6.xlsm

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,099

    Re: need to save sheet as a copy every time sheet is up dated

    Hi, superchew,

    maybe have a look at SaveCopyAs in the VBA Help for copying (the format will equal the one of the original workbook).

    Just for curiosity:
    Please Login or Register  to view this content.
    0 equals False in VBA - why are you turning the events off at the end of the macros? True equals -1 in VBA. The whole code should get a rework in order of clearer structure.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  5. #5
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: need to save sheet as a copy every time sheet is up dated

    I am very new at this so i don't know best way to structure

  6. #6
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: need to save sheet as a copy every time sheet is up dated

    save copy as only works once, then when i put another number in D1 it doesn't save it as a copy

+ 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. Replies: 4
    Last Post: 09-03-2013, 09:56 AM
  2. [SOLVED] Copy Data and paste it in new sheet and save new sheet as value of cell a2
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2013, 08:55 AM
  3. Copy cells to new Sheet and Save Sheet
    By DadaaP in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2013, 10:34 AM
  4. re:Check for dated sheet
    By Mike K in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2005, 09:06 PM
  5. [SOLVED] Check for dated sheet
    By Mike K in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2005, 07:06 AM

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