Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Sub List_Path_Of_Files() 'List Files (entire path) from a given directory in Column A of current excel worksheet 'requires a folder picker to be perfect Dim MyFolder As String Dim MyFile As String Dim a As Integer MyFolder = "C:\Test\" ' <-- Change to your folder MyFile = Dir(MyFolder & "*.*") a = 0 Do While MyFile <> "" a = a + 1 Cells(a, 1).Value = MyFolder & MyFile MyFile = Dir Loop MsgBox "Done. Column A lists all of the files of the given directory" End Sub
|Function for selecting rows from data set and combining certain rows based on criteria||16||30|
|Move data from one sheet to another||11||30|
|Excel Drop Down List||13||30|
|macro modification Column C||14||25|