我的代码如下
Dim ExcelApp As Excel.Application, workbook10 As Excel.workbook, worksheet10 As Excel.worksheet
Dim i As Integer, Datetime() As Date, Waveheight() As Integer, Datetime0 As Date, Datetime00 As Date, Datetime000 As Date, Waveheight0 As Integer, Waveheight00 As Integer, Waveheight000 As Integer,
ReDim Datetime(1 To 1393)
ReDim Waveheight(1 To 1393)
For i = 1 To 1392
Set workbook10 = GetObject(m.Path & "chaoxi.xls")
Set worksheet10 = workbook10.ActiveSheet
Datetime00 = Format(NOW,"YYYY-MMMM-DD H:mm")
Datetime(i) = Format(worksheet10.cells(i, 1).value, "YYYY-MMMM-DD H:mm")
Waveheight(i) = worksheet10.cells(i, 2).value
If Datetime00 >= Datetime(i) And Datetime00 <= Datetime(i + 1) Then
Datetime0 = Datetime(i)
Datetime000 = Datetime(i + 1)
Waveheight0 = Waveheight(i)
Waveheight000 = Waveheight(i + 1)
Waveheight00 = Waveheight000 * (DateDiff("n", Datetime00, Datetime0) / DateDiff("n", Datetime000, Datetime0)) + Waveheight0 * (DateDiff("n", Datetime000, Datetime00) / DateDiff("n", Datetime000, Datetime0))
End If
Next i
里面的worksheet10里的数据第一列为日期数据,第二列为整型数据例如
2010-1-1 2:17 166
2010-1-1 6:50 141
2010-1-1 11:48 171
2010-1-1 19:49 11
2010-1-2 2:58 167
2010-1-2 7:33 139
2010-1-2 12:42 174
2010-1-2 20:32 10程序运行到Datetime(i) = Format(worksheet10.cells(i, 1).value, "YYYY-MMMM-DD H:mm")
时出现类型不匹配提示
欢迎大家来指教
Dim ExcelApp As Excel.Application, workbook10 As Excel.workbook, worksheet10 As Excel.worksheet
Dim i As Integer, Datetime() As Date, Waveheight() As Integer, Datetime0 As Date, Datetime00 As Date, Datetime000 As Date, Waveheight0 As Integer, Waveheight00 As Integer, Waveheight000 As Integer,
ReDim Datetime(1 To 1393)
ReDim Waveheight(1 To 1393)
For i = 1 To 1392
Set workbook10 = GetObject(m.Path & "chaoxi.xls")
Set worksheet10 = workbook10.ActiveSheet
Datetime00 = Format(NOW,"YYYY-MMMM-DD H:mm")
Datetime(i) = Format(worksheet10.cells(i, 1).value, "YYYY-MMMM-DD H:mm")
Waveheight(i) = worksheet10.cells(i, 2).value
If Datetime00 >= Datetime(i) And Datetime00 <= Datetime(i + 1) Then
Datetime0 = Datetime(i)
Datetime000 = Datetime(i + 1)
Waveheight0 = Waveheight(i)
Waveheight000 = Waveheight(i + 1)
Waveheight00 = Waveheight000 * (DateDiff("n", Datetime00, Datetime0) / DateDiff("n", Datetime000, Datetime0)) + Waveheight0 * (DateDiff("n", Datetime000, Datetime00) / DateDiff("n", Datetime000, Datetime0))
End If
Next i
里面的worksheet10里的数据第一列为日期数据,第二列为整型数据例如
2010-1-1 2:17 166
2010-1-1 6:50 141
2010-1-1 11:48 171
2010-1-1 19:49 11
2010-1-2 2:58 167
2010-1-2 7:33 139
2010-1-2 12:42 174
2010-1-2 20:32 10程序运行到Datetime(i) = Format(worksheet10.cells(i, 1).value, "YYYY-MMMM-DD H:mm")
时出现类型不匹配提示
欢迎大家来指教
解决方案 »
- Function的问题
- 有没有一个函数能知道一个动态数组有没有被ReDim过?
- ActiveReport中打印报表采用针打对打印机有什么要求吗?另外纸型的设置有什么要求
- 如何在窗口左下角右边3CM,往上2CM处,模拟鼠标点击一下???
- 怎么样才能在listview控件的一个列,加上check控件?这样可以在该列做选择或不选择的打勾。还有,左边要做一个能像资源管理器那样打开一
- VBA可以读数据库中的图片文件吗?
- 使用dateadd()函数要引用什么文件?????急!!!!!
- 用 FileCopy 复制数据库时 数据库用不用关闭如果用关闭怎么关闭,我用的是孔件 Data 和 Adodc
- 如何在VB中启动邮件客户端?
- 我想使用winsock控件来编写一个只发送的程序
- 准备出差,出差地点,辽宁鞍山,夜里12点从北京出发,有顺路的没?
- 为啥DataGrid控件的数据都是空白的
ReDim Datetime(1 To 1393)ORdim Datetime()
ReDim Datetime(1 To 1393)
worksheet10.cells(i, 1).text