problemas com referencia do OFFICE

Klebão

20-04-2016 16:53:07

Pessoal,

Troquei meu office 2010 pelo 2013 e algumas macros apresentaram "erro em tempo de execução 9" subscrito fora do intervalo quando chega na parte " Windows("Pasta3").Activate". Podem me ajudar?

Sub CARGA_SELL()
'
' CARGA_SELL Macro
'

'
Range("B2:C2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range("B2:R2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("AJUSTE CARGA SELL").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Cells.Select
Application.CutCopyMode = False
Selection.NumberFormat = "@"
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Range("B2").Select
ActiveSheet.Range("$A$1:$Q$38").AutoFilter Field:=2, Criteria1:="="
Range("C10").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Delete
ActiveWindow.ScrollRow = 1
ActiveSheet.Range("$A$1:$Q$10").AutoFilter Field:=2
Rows("10:10").Select
Selection.Delete Shift:=xlUp
Range("A1").Select
Selection.AutoFilter
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Workbooks.Add
Windows("Pricing atual.xlsb").Activate
Windows("Pasta3").Activate
ActiveSheet.Paste
Cells.Select
Cells.EntireColumn.AutoFit
Range("H3").Select
Application.CutCopyMode = False
ChDir "D:\Users\kleber.freitas\Desktop"
ActiveWorkbook.SaveAs Filename:="D:\Users\kleber.freitas\Desktop\BASE0.csv", _
FileFormat:=xlCSV, CreateBackup:=False
Range("H3").Select
Windows("Pricing atual.xlsb").Activate
Selection.ClearContents
Sheets("CARGA SELL").Select
Range("A2").Select
End Sub

Mauro Coutinho

22-04-2016 01:33:37

O erro "erro em tempo de execução 9" subscrito fora do intervalo", acontece não devido a versão e sim ele está informando que a "pasta3" não existe ou não está aberta, se fosse problema de versões daria erro nas outras linhas antes.