Excel Macro and VBA Extract the filename of a file in a Folder
HTML-код
- Опубликовано: 13 окт 2024
- This video shows you how to find the file name of a file in a specified folder and then use that file name along with the file path in your Macro. This helps when you have created a Macro that refers to a filename but then people keep sending you the data but with different file names. This makes your macro more dynamic by allocating the file name and path to Variables in your VBA code.
SAMPLE:
Sub GetFileName()
'This will get the name of the first file in the folder
'David Ludlow InIT Learning
'One-day Excel Courses
'www.initlearni...
Dim FileName As String
Dim PathName As String
Dim FullFileName As String
'Enter your File Path
PathName = "C:\YOURFILEPATH\"
FileName = Dir(PathName & "*.*")
FullFileName = PathName & FileName
MsgBox (FullFileName)
End Sub
Wonderful!! It's helping me to learn VBA code, thank you very much for the information
You’re very welcome
Wonderful.
If i have a file name for example "data_date_time" date can be 22_2_2022 and time can be 18_00 is it possible to use the wild card only for one specific part of the file name
Super useful for a beginner like me.
Thanks a lot!!
Glad it was helpful!
I want to create a macro where it extracts multiple file paths within a folder as hyperlinks - any way to do this?
Thank you so mutch.
You're welcome!