VBA to transfer data from one workbook to another - Page 2
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24

Thread: VBA to transfer data from one workbook to another

  1. #11
    New Member
    Join Date
    Jun 2017
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

     
    Done. Received the same error message. I wish I could post attachments!!

  2. #12
    New Member
    Join Date
    Jun 2017
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

    Wait...does this code need to be created as a module or a pasted into my form code?

  3. #13
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,648
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

    If you want, upload them to a file sharing service such as dropbox and post the link. I can try to take a look at them tonight when I'm not on a work computer.
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  4. #14
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,648
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

    Quote Originally Posted by Robert_Conklin View Post
    Wait...does this code need to be created as a module or a pasted into my form code?
    In a module
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  5. #15
    New Member
    Join Date
    Jun 2017
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

    Ok, that is where I put it. Do you have somewhere I can send these files so you can see what I am looking at?

  6. #16
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,648
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

    Quote Originally Posted by Robert_Conklin View Post
    Ok, that is where I put it. Do you have somewhere I can send these files so you can see what I am looking at?
    See my above post about Dropbox.
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  7. #17
    New Member
    Join Date
    Jun 2017
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

    https://www.dropbox.com/sh/qq5rbvwjc...H2sjGF0ha?dl=0. Hopefully you can see them with the link. I am headed home for the evening. Thanks for your help.

  8. #18
    New Member
    Join Date
    Jun 2017
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

    Were you able to get to the files from the dropbox link?

  9. #19
    Board Regular MrKowz's Avatar
    Join Date
    Jun 2008
    Location
    St. Louis, MO
    Posts
    6,648
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

    Sorry, I didn't have a chance last night to take a look. You're still on my radar, though.
    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    - Please use [CODE] [/CODE] tags when posting your VBA code. It retains spacing, so your code is easier to read, and therefore easier to debug.
    - Please back up your file before using any macros suggested!

  10. #20
    New Member
    Join Date
    Jun 2017
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to transfer data from one workbook to another

      
    No problem, thank you for your help.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com