Trying this way but still getting same error....
I have my old file in web for perfect example http://www.box.net/shared/4ohcogad68
I open the link, open the file but did not save it to the desktop and I'm tryin to get the data across to Try.xlsm
Please do try this example and see if same thing happens to you...
Maybe I'm doing a small thing wrong which is why it is not working...
Dim wb As Workbook, myfile As String
'i also tried "Workbooks("For Pedie(1).xls").Activate" this way but still same error message...
'Try.xlsm is in my desktop
Application.CutCopyMode = False
Vog, thank you so much again. I dont mean to trouble you this far....
I'll be fine...whenever you're free please try it out and see if you can make it work.