hi guys ,
I have this bit of code
[vba]With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
If .Show = -1 Then
Workbooks.Open (.SelectedItems(1))
NewWBName = ActiveWorkbook.Name
End If
End With
' this bit is wrong
Set OldBook = NewWBName.Sheets(1)
Set NewBook = Workbooks.Add
[/vba]
So what i am tryin to accomplist is seeting the variable OldBook to be the "new" workbook that has just been opend
***
Edited the code