aysam
03-05-2010, 09:48 AM
PEACE to you all
I had a code from this VBA Express to open a file
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
If .Show = -1 Then
Workbooks.Open (.SelectedItems(1))
End If
End With
I need to add a piece of code to copy a range from the opened file and paste to the main file starting at a certain row ( A1)
thanks in advance
greatly appreciated
AYSAM
I had a code from this VBA Express to open a file
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
If .Show = -1 Then
Workbooks.Open (.SelectedItems(1))
End If
End With
I need to add a piece of code to copy a range from the opened file and paste to the main file starting at a certain row ( A1)
thanks in advance
greatly appreciated
AYSAM