Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel Macro and VBA Extract the filename of a file in a Folder. That video is uploaded by InIT Learning at 2021-04-16T06:29:46-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [VMPhylw47-I]
| Name | Excel Macro and VBA Extract the filename of a file in a Folder |
| Video Uploader | Video From InIT Learning |
| Upload Date | This Video Uploaded At 16-04-2021 13:29:46 |
| Video Discription | 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 'https://www.initlearning.net 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 VMPhylw47-I |
| Category | Education |
| Tags | Computer Tips | Employment Tips | Unboxing |
