Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all, I am using Visual Basic 2008. I am working on code with which
I can copy specified extention files from one folder to other. I need two codes, one which can copy files of specified extention only from top main folder and two which can copy files of specified extention from top main folder as well as from all the subfolder which exist in that top main folder. In these both codes I also need to have progress bar code to show user the progress. I am struggling on this and so far i came up with code (see below) which only copies files from top main folder and i am getting error on line "ProgressBar1.Value = (n / Fldrfl.Count) * 100". I'll be very greatful if any friend can help me on this. Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim FldrNm As String Dim Fso As Object Dim Fldr As Object Dim Fldrfl As Object Dim n As Long FldrNm = TextBox1.Text Fso = CreateObject("Scripting.FileSystemObject") Fldr = Fso.GetFolder(FldrNm) For Each Fldrfl In Fldr.Files If Microsoft.VisualBasic.Right(Fldrfl.Name, Microsoft.VisualBasic.Len(Fldrfl.Name) - Microsoft.VisualBasic.InStrRev(Fldrfl.Name, ".")) = TextBox2.Text Then Fldrfl.Copy(TextBox3.Text & "\" & Fldrfl.Name) n = n + 1 ProgressBar1.Value = (n / Fldrfl.Count) * 100 Application.DoEvents() End If Next Fldrfl = Nothing Fldr = Nothing Fso = Nothing MsgBox("Files have been copied successful!", MsgBoxStyle.Information, "Done!") End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Files to other folder | Excel Programming | |||
How to copy 30 csv files from a folder to another folder | Excel Programming | |||
Copy files from spreadsheet into folder | Excel Discussion (Misc queries) | |||
Copy same data from all files in folder | Excel Programming | |||
Copy Files from a folder to new location | Excel Programming |