bopha99
02-04-2014, 06:30 PM
I have a code below where when I run it gives me a Runtime error 9 sub script out of range error. The code works, but it still gives me that error. Does that mean the VBA code cannot locate the csv file mentioned on the debug row? Thanks in advance.
Sub Price()
'Price Macro
Columns("C:E").Select
Selection.Delete Shift:=xlToLeft
Range("A1").Select
ActiveCell.FormulaR1C1 = "Ticker"
Range("B1").Select
ActiveCell.FormulaR1C1 = "CustomTradePrice"
Columns("B:B").Select
Windows("mBOSExport%20OCM%20Daily%20Prices%20##20110706.csv").Activate <= debug problem
Windows("Prices.csv").Activate
Range("C1").Select
End Sub
Sub Price()
'Price Macro
Columns("C:E").Select
Selection.Delete Shift:=xlToLeft
Range("A1").Select
ActiveCell.FormulaR1C1 = "Ticker"
Range("B1").Select
ActiveCell.FormulaR1C1 = "CustomTradePrice"
Columns("B:B").Select
Windows("mBOSExport%20OCM%20Daily%20Prices%20##20110706.csv").Activate <= debug problem
Windows("Prices.csv").Activate
Range("C1").Select
End Sub