|
本帖最后由 对你微笑 于 2015-12-14 11:43 编辑
求助:跨工作簿保存代码
Sub LED显示()
Dim sh As Worksheet, FF As Workbook, arr
Application.ScreenUpdating = False
Set sh = ActiveSheet
Set FF = GetObject(ThisWorkbook.Path & "\" & "LED数据.xls")
arr = sh.Range("A34:B34")
FF.Sheets("LED").[A65535].End(xlUp).Offset(1, 0).Resize(1, 2) = arr
Application.Windows(FF.Name).Visible = True
FF.Close True
Application.ScreenUpdating = True
End Sub
求助:1、跨工作簿保存可否从第一行开始保存;
2、可否对保存的数据进行清空(每天的保存数据从第一行开始保存)。
- Sub LED显示1()
- Dim sh As Worksheet, FF As Workbook, arr
- Application.ScreenUpdating = False
- Set sh = ActiveSheet
- Set FF = GetObject(ThisWorkbook.Path & "" & "LED数据1.xls")
- arr = sh.Range("A34:B34")
- If FF.Sheets("LED1").[A1] = "" Then
- FF.Sheets("LED1").[A1].End(xlUp).Resize(1, 2) = arr
- Else
- FF.Sheets("LED1").[A65535].End(xlUp).Offset(1, 0).Resize(1, 2) = arr
- End If
- Application.Windows(FF.Name).Visible = True
- Application.DisplayAlerts = False '关闭警告和消息
- FF.Close True
- Application.ScreenUpdating = True
- End Sub
复制代码
|
|