1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

vba to save file as a new file and record data into existing data sheet

Discussion in 'Business Applications' started by jeffchew, Sep 26, 2014.

Thread Status:
Not open for further replies.
  1. jeffchew

    jeffchew Thread Starter

    Joined:
    Sep 26, 2014
    Messages:
    2
    Hi there,

    Here is what I want to do with my current excel file:

    1. Click Save button to save all required data to another sheet
    2. The number highlighted in reed need to be auto increment (+1) each time save button is click
    3. Then the file will save as a new excel file with the form number (SRF-ABC-1001-14.xls)
    4. And clear the current form and exit excel

    Please refer my attached file for the sample what I want to do.

    Please note the number highlighted in red should be auto increment number, once click save button, the file will automatic save as a new excel with the Form name.

    Thank you so much for your help and time reading this.
     

    Attached Files:

  2. jeffchew

    jeffchew Thread Starter

    Joined:
    Sep 26, 2014
    Messages:
    2
    anyone able to assist me?

    I'm looking forward to learn hence I appreciate each code have a comment on top of it and provide me some samples of code and I'll workout the rest.

    Thanks.
     
  3. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,559
    First Name:
    Hans
    Hi, welcome to the forum.

    I'll take a look and see if I can understand what you require.
    You've added another requirement in the file too.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1134334

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice