+ Reply to Thread
Results 1 to 2 of 2

Macro between different documents

  1. #1
    Registered User
    Join Date
    10-09-2015
    Location
    Sweden
    MS-Off Ver
    Office 2015
    Posts
    1

    Question Macro between different documents

    Hi!
    I have two separate documents, and I would like to insert two different Macros.

    The first one, introducing (should start when opening document), is supposed to look in doc 1, search for the next number in order (lets say its the 3rd document I create, therefor the next number should be 3) and then input number 3 in a specifik area (H2).

    Then, manually, the document is filled in and finished.

    The last, finishing macro, should now copy 4 different specifik data in the document that is filled in.
    F9:I9 --> B (and the next empty number)
    B15:C15 --> C (and the next empty number)
    I5 --> D (and the next empty number)
    I53 --> E (and the next empty number)

    After this is filled in, this second document should be saved in a specifik place.

    Than back to the first manuelly filled document, should be renamed after the input number (in this case 3) and saved on a specifik place.

    Is this possible?

    greetings,
    Rasmus

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello FairTreat Sverige AB,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Separating a documents worksheets into individual documents
    By CWinkler in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-30-2019, 07:22 PM
  2. Documents and Settings All Users Documents - Access is denied
    By peterrc in forum Microsoft Windows Help
    Replies: 8
    Last Post: 01-26-2014, 06:30 AM
  3. convert all 97-2003 excel documents to macro enabled documents on server
    By viperisback in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2013, 09:06 AM
  4. Form documents-Macro or VBA?
    By i82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2012, 04:48 AM
  5. Creating a macro for all documents
    By stevie_p in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2007, 08:20 AM
  6. Applying a simple macro over 100 documents
    By FouTight in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2007, 12:01 PM
  7. excel documents won't open from my documents folder
    By Paul1961 in forum Excel General
    Replies: 2
    Last Post: 01-15-2006, 01:35 PM
  8. [SOLVED] Excel Documents Don't Appear in My Recent Documents
    By Addi in forum Excel General
    Replies: 4
    Last Post: 07-24-2005, 05:05 PM

Tags for this Thread

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