Bonjour, comment dfinir une zone d’impression avec la classe “ExcelAreas” ??
mais comment crire le code, je bloque compltement…
merci.
Bonjour, comment dfinir une zone d’impression avec la classe “ExcelAreas” ??
mais comment crire le code, je bloque compltement…
merci.
Here is an example that shows a print area. Does your question mean ExcelAreas = PrintArea?
[code]Dim excel as new ExcelApplication
excel.Workbooks.Add
excel.visible = true
//New data in cells
excel.Range(“A1:C3”).Value = “text”
//Print cell data
excel.ActiveSheet.PageSetup.PrintArea = “A1:B2”
MsgBox “Print area has a box on Excel”
excel.ActiveSheet.Range(“A1:B2”).Printout
//Close excel
excel.ActiveWorkbook.close false
excel.Quit
excel = nil
Exception err as OLEException
MsgBox err.message[/code]
Let me know if I misunderstand.
[quote=333048:@Eugene Dakin]Here is an example that shows a print area. Does your question mean ExcelAreas = PrintArea?
[code]Dim excel as new ExcelApplication
excel.Workbooks.Add
excel.visible = true
//New data in cells
excel.Range(“A1:C3”).Value = “text”
//Print cell data
excel.ActiveSheet.PageSetup.PrintArea = “A1:B2”
MsgBox “Print area has a box on Excel”
excel.ActiveSheet.Range(“A1:B2”).Printout
//Close excel
excel.ActiveWorkbook.close false
excel.Quit
excel = nil
Exception err as OLEException
MsgBox err.message[/code]
Let me know if I misunderstand. :)[/quote]
Oui, je voulais savoir s’il fallait utiliser excelarea for printarea, mais je vois que non!!
Merci beaucoup ! C’est super !