Well, you should at least demonstrate that you have tried ...
However, in VB is very simple interface for Office applications and manage the FileSystem.
Did I make a sample to 90% resolve your problem:
I have a file "Elenco.xls" in A1, A2, A3 contains 3 names of existing files (in my example are in dir "Files" located in the dir - relative path). In B1, B2, B3 I have names corresponding to change.
There are several ways to read from a file in VB Xls. Use the classic without trouble Ado:
-> Functions used by the main code:
Code:
Private Declare Function GetWindowThreadProcessId Lib "user32" (ByVal hWnd As Integer, ByRef lpdwProcessId As IntPtr) As IntPtr
Private Function seFileEsiste (ByVal nomeCompFile As String) As Boolean
Dim F As New System.IO.FileInfo (nomeCompFile)
If Exists Then F.
seFileEsiste = True
Else
seFileEsiste = False
End If
End Function
And that's it.
Once again, the My NameSpace simplifies matters further.
Bookmarks