Question about VBA

[Anri]

Dears ,

I am new to the VBA language in Excel. I have a problem and I want to solve it using this language.
How can I link three Excel files into one file, or in other words, I want the data of the three Excel files to be transferred to one file?

Regards,

 

[rlv01]

If you are new to VBA, then you will need to learn more about the language before any description of how to do that will have any meaning for you. If you have any programming experience with other programming languages, then climbing the learning curve will be faster.

A good primer for VBA newbies.

Learn VBA Macro Coding Basics In Excel [2024 Guide]

This beginners guide will teach anyone how to get started with coding VBA macros in Excel. This quick start guide assumes you have no coding experience and teaches you the main components in simplistic terms so you can have a basic understanding of what VBA macros are all about. After reading...

www.thespreadsheetguru.com

There are also a number of good introductory VBA videos on youtube.

Good luck.

 

[Edgar_]

The most common approach from a VBA standpoint is to adapt something like:
Set wb = Workbooks.Open(filePath)
Where wb is a variable declared as workbook and filePath is a variable declared as string. With this setup, you can manipulate the opened workbook's worksheets to get the data you need. Once you have the data, you can close the file. For example, if you wanted to extract the first cell of the first sheet of the newly opened workbook into cell F1 of the first sheet of the current workbook, you'd do something like this:

Sub test()
    Dim filePath As String
    filePath = "C:\someFile.xlsx"
    
    Dim wb As Workbook
    Set wb = Workbooks.Open(filePath)
    
    ThisWorkbook.Sheets(1).Range("F1") = wb.Sheets(1).Range("A1")
    wb.Close
End Sub

Since you need 3 files, you can use a loop or write the 3 file paths in the code, but the most efficient way is to just make functions that can handle this task dynamically.

 

[Anri]

If you are new to VBA, then you will need to learn more about the language before any description of how to do that will have any meaning for you. If you have any programming experience with other programming languages, then climbing the learning curve will be faster.

A good primer for VBA newbies.

Learn VBA Macro Coding Basics In Excel [2024 Guide]

This beginners guide will teach anyone how to get started with coding VBA macros in Excel. This quick start guide assumes you have no coding experience and teaches you the main components in simplistic terms so you can have a basic understanding of what VBA macros are all about. After reading...

www.thespreadsheetguru.com

There are also a number of good introductory VBA videos on youtube.

Good luck.

Thank you, I appreciate that very much. I really need to learn a lot in this language, but I don’t know where to start

 

[Anri]

The most common approach from a VBA standpoint is to adapt something like:
Set wb = Workbooks.Open(filePath)
Where wb is a variable declared as workbook and filePath is a variable declared as string. With this setup, you can manipulate the opened workbook's worksheets to get the data you need. Once you have the data, you can close the file. For example, if you wanted to extract the first cell of the first sheet of the newly opened workbook into cell F1 of the first sheet of the current workbook, you'd do something like this:

Sub test()
    Dim filePath As String
    filePath = "C:\someFile.xlsx"
   
    Dim wb As Workbook
    Set wb = Workbooks.Open(filePath)
   
    ThisWorkbook.Sheets(1).Range("F1") = wb.Sheets(1).Range("A1")
    wb.Close
End Sub

Since you need 3 files, you can use a loop or write the 3 file paths in the code, but the most efficient way is to just make functions that can handle this task dynamically.

Thank you very much Edgar. It worked. Can I make it open for me the location of the three files and I choose them, for example, the October, November or December file, but I want to continue opening the selection option over the years?