Please check my code. Getting runtime error 9. Subcript out of range

[pedie]

sub try()
Windows("trybook[2].xls1").Activate
cells(1).select
 
End Sub

 

[pedie]

Anyone else...any suggestion?

 

[meldoc]

Using the method and example file, from post #10, and the code below, it works for me in 2007.

Sub try()
  Windows("For Pedie[1].xls").Activate
  Cells(1, 1).Copy Workbooks("Book1").Sheets("Sheet1").Cells(1, 1)
End Sub

In 2010 I got the runtime error 9. Subcript out of range message, and had to Enable Editing on the Protected View bar, after that it worked OK.

See the links.

http://office.microsoft.com/en-gb/p...tecting-your-files-RZ101665538.aspx?section=7

http://office.microsoft.com/en-us/excel-help/what-is-protected-view-HA010355931.aspx

 

[pedie]

Hi Brian,

Yesterday went to sleep early and today i was busy through out the day @ work so couldnt spent time with this thread....!

Anways...want to say thanks for alot for suggestion and for researching for me. Now it seems to work in xls 07, i'll try in 10 when i get to work again...hopefully it should work like you have suggested...


Thanks again and have a great weekend!
And thanks again to Vog and everyone who helped.