VBA copy from different files
Results 1 to 3 of 3

Thread: VBA copy from different files
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face VBA copy from different files

    Hi,
    I am trying to copy into an excel file the data stored into two different excel files.
    I am doing this process in a very repetitive way and I would like to automatize most of it.
    The macro basically have to:

    1) Ask me which is the file A.
    2) Ask me which is the file B.
    3) Copy some values from different tabs in A.
    4) Paste those values in file C.
    5) Copy some values from different tabs in B after summing values according to a filter.
    6) Paste those values in file C.

    Could you help me with the basic structure of the macro, I am struggling with it. I already started with the process to actually select the file instead of writing the full path….but I am stucked.

    Dim path As String
    With Application.FileDialog(msoFileDialogOpen).Show
    If .SelectedItems.Count = 1 Then
    path = .SelectedItems(1)
    End If
    End With


    I would appreciate any help or other similar old post I could not find

  2. #2
    New Member
    Join Date
    May 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA copy from different files

    maybe msoFileDialogPicker ?

  3. #3
    New Member
    Join Date
    May 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA copy from different files

    Anyone with any similar macro done somehow?

Some videos you may like

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
  •