这曾经起作用,然后突然开始出现错误:
“对象”全局范围的方法“范围”失败
从以下行开始:
Range("G2.G101").Value = "=E2-B2"
有什么作用?
Sub ReadCSV()
Dim symbol,hi,lo,startdate,enddate,hi2,lo2,hi3,lo3,d5hi,d5lo,d10hi,d10lo,d20hi,d20lo,dayrng As Variant
Dim symbpos As Range
Dim MainWkbk,NextWkbk As Workbook
Set MainWkbk = activeWorkbook
'symbol = InputBox("Enter symbol")
symbol = activeCell.EntireRow.Cells(1).Value
Workbooks.Open Filename:="f:\downloads\daily_" & symbol & ".csv"
Set NextWkbk = activeWorkbook
Range("G1").Value = "Net Ch fr Open"
Range("G2.G101").Value = "=E2-B2"
End Sub