|
楼主 |
发表于 2024-3-21 10:09
|
显示全部楼层
老师您好
Sub yy()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim fso, fl, fp
Dim wb As Workbook
Set fso = CreateObject("Scripting.FileSystemObject")
fp = CreateObject("Shell.Application").BrowseForFolder(0, "请选择文件夹", 0, "").Self.Path & ""
'mys = InputBox("请输入需要更改的名称。")
For Each fl In fso.getfolder(fp).Files
If InStr(fl.Name, ThisWorkbook.Name) = 0 Then
Set wb = Workbooks.Open(fl)
With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
Range("A1").Select
ActiveCell.FormulaR1C1 = ActiveSheet.Range("A1").Value
End With
wb.Close True
End If
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
我想把宏文件A1表格中的数据写入到目标文件A1表格中,试了半天也不行,麻烦您给修改下 |
|