dim oExcel,oWb,oSheet,temp,fso,os
Set oExcel= CreateObject("Excel.Application")
Set fso = CreateObject("Scripting.FileSystemObject")
Const TemporaryFolder = 2
Set temp = fso.GetSpecialFolder(TemporaryFolder)
Set oWb = oExcel.Workbooks.Open(temp & "\test.xls")
oExcel.Application.Visible=True
For i=1 To oWb.Sheets.Count
Set oSheet = oWb.WorkSheets(i)
oSheet.printpreveiw
Next
oExcel.Quit现在有这么个要求: 操作excel打印预览所有的工作表,就相当于选中所有工作表,然后打印预览的效果求高手解惑!!!!!
Set oExcel= CreateObject("Excel.Application")
Set fso = CreateObject("Scripting.FileSystemObject")
Const TemporaryFolder = 2
Set temp = fso.GetSpecialFolder(TemporaryFolder)
Set oWb = oExcel.Workbooks.Open(temp & "\test.xls")
oExcel.Application.Visible=True
For i=1 To oWb.Sheets.Count
Set oSheet = oWb.WorkSheets(i)
oSheet.printpreveiw
Next
oExcel.Quit现在有这么个要求: 操作excel打印预览所有的工作表,就相当于选中所有工作表,然后打印预览的效果求高手解惑!!!!!
Dim aSheets() As Variant
Dim i As Long
ReDim aSheets(1 To oWb.Sheets.Count)
For i = 1 To oWb.Sheets.Count
aSheets(i) = oWb.Sheets(i).Name
NextSheets(aSheets).PrintPreview
Set oExcel= CreateObject("Excel.Application")
Set fso = CreateObject("Scripting.FileSystemObject")
Const TemporaryFolder = 2
Set temp = fso.GetSpecialFolder(TemporaryFolder)
Set oWb = oExcel.Workbooks.Open(temp & "\test.xls")
oExcel.Application.Visible=True
Dim aSheets() As Variant
Dim i As Long
ReDim aSheets(1 To oWb.Sheets.Count)
For i = 1 To oWb.Sheets.Count
aSheets(i) = oWb.Sheets(i).Name
NextSheets(aSheets).PrintPreview
os.PrintPreview楼上大神,还是不行厄= =