+ Reply to Thread
Results 1 to 1 of 1

Create automatically excel new file based on a template from info entered in another file

  1. #1
    Forum Contributor
    Join Date
    10-07-2015
    Location
    cyprus
    MS-Off Ver
    2010
    Posts
    173

    Create automatically excel new file based on a template from info entered in another file

    Good morning,

    I have a file named "cargoes 2016" for which I created a userform in order to enter easily all the infos in all the relevant sheets. This works perfectly.

    However I would like to add a new macro creating automatically a new file based on the template "CALC(P) - - - + CALC(S) - - -" and based of the new datas entered in cargos 2016 (i.e. after clicking on "add" on the user form of cargoes 2016.


    However being totally inexperienced in VBA, I would like to know:

    1. if my idea is feasible
    2. any leads for further search on vba code/macro

    Please note that for forum restrictions purposes, the file "CALC(P) - - - + CALC(S) - - -test" is actually a "Microsoft Excel Macro-Enabled Template (.xltm)"
    Attached Files Attached Files

+ 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. Create Outlook Template (.oft) from Excel file
    By dkeller33 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 11-25-2014, 03:36 PM
  2. Macro to AutoFilter create PDF/Mail and copy selected data to Template Excel file
    By iancoupal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2014, 05:47 PM
  3. Automatically create file and fill in three cells from data in csv or other excel file
    By jamielpeters in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-16-2013, 06:19 PM
  4. use entered info to find and open file
    By lax2734 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2012, 01:53 PM
  5. Replies: 1
    Last Post: 07-16-2009, 09:14 PM
  6. Replies: 0
    Last Post: 11-08-2007, 04:14 AM
  7. Excel file automatically opens - More Info
    By Lost4Now in forum Excel General
    Replies: 2
    Last Post: 12-04-2005, 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