Excel page break from vba code

  • Thread starter Thread starter Philippe
  • Start date Start date
P

Philippe

Hi,

I am currently trying to insert page break into an Excel
sheets from Access but without success. I actually send
data from access through vba. Any ideas?

:P hilippe
 
from the help.
Where xlSheet would be the excel sheet you are handling in access.

This example sets a manual page break above row 25 on Sheet1.
xlSheet.Rows(25).PageBreak = xlPageBreakManual

This example sets a manual page break to the left of column J on Sheet1.
xlSheet("Sheet1").Columns("J").PageBreak = xlPageBreakManual
if it doens't link xlPageBreackManual try adding this (its the contstant in
excel)Const xlPageBreakManual = -4135 (&HFFFFEFD9)Rodrigo."Philippe"
 
Back
Top