Choose File and Use

[_eNVy_]

Hi,

Essentially, every week there is a new file saved (wb1) in a new folder destination within a Network Drive (sadly the filename always changes depending on the date).
This file is then used to populate another (current workbook).

I wish to have the user choose the file (wb1) and upon opening the file, have the code identify the opened file as wb1.

Then I can do simple tasks such as copying data from wb1 into the current workbook.

Is there an easy way of writing this out so that I may easily digest it?

 

[GWteB]

Is this what you're looking for? This function lets users pick a workbook and open it.

Public Function GetWbk() As Workbook
    Dim oWb         As Workbook
    Dim sWbkName    As String

    sWbkName = Application.GetOpenFilename("Excel Workbooks,*.xlsx;*.xlsm;*.xlsb;*.xls")
    If sWbkName <> "False" Then
        Set oWb = Application.Workbooks.Open(sWbkName)
    End If
    Set GetWbk = oWb
    Set oWb = Nothing
End Function

 

[_eNVy_]

Is this what you're looking for? This function lets users pick a workbook and open it.

Public Function GetWbk() As Workbook
    Dim oWb         As Workbook
    Dim sWbkName    As String

    sWbkName = Application.GetOpenFilename("Excel Workbooks,*.xlsx;*.xlsm;*.xlsb;*.xls")
    If sWbkName <> "False" Then
        Set oWb = Application.Workbooks.Open(sWbkName)
    End If
    Set GetWbk = oWb
    Set oWb = Nothing
End Function

Can this be explained?
Once the file has been opened, I wish to extract information from it.
Where is the definition of the opened file? Is it oWb?
Where would I put my own coding to do the extraction of information?

Thank you for your assistance.

 

[GWteB]

To what extent are you familiar with VBA?

 

[_eNVy_]

To what extent are you familiar with VBA?

I can do simple tasks but when trying to copy data from the opened worked book - not current, it is not recognising oWb.
I wish for the code to be broken down so that I can fully understand it.

 

[_eNVy_]

Never mind. Sussed it.

Thanks!

 

[smozgur]

@_eNVy_: Please do not mark a post as the solution that doesn't contain an answer.

Note: Post #2 answers this question. Therefore, it has been marked as the solution to help future readers.