Date

[Guest]

I have a master wookbook that need to update weekly. The new information
comes from a file that sent to me every week(the name of the file changes to
reflect the updated date). I want to use macro to automate this process.
Everything work out fine but I don't know how to change the file name in
macro.

Any advice is highly appreciated.

Jason

 

[Debra Dalgleish]

You could store the file name in a cell in the macro workbook, and
change or recalculate it as required. For example:

Sub OpenMyFile()
Dim strFilePath As String
Dim strFileName As String

strFilePath = "c:\Data\"
strFileName = Worksheets("Sheet1").Range("A1").Value

Workbooks.Open strFilePath & strFileName

End Sub

 

[Guest]

Thanks a lot, Debra.

Jason

You could store the file name in a cell in the macro workbook, and
change or recalculate it as required. For example:

Sub OpenMyFile()
Dim strFilePath As String
Dim strFileName As String

strFilePath = "c:\Data\"
strFileName = Worksheets("Sheet1").Range("A1").Value

Workbooks.Open strFilePath & strFileName

End Sub