Pagebreak in Excel from VBA Access

[tdubs]

Hi,

How can I make a pagebreak in a excel spreadsheet from VBA ACCESS

I recorded a macro in excel to see how is the syntax of the code....

it came out to be
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell


so I change my code to
xlbook.Sheets(sheetname).HPageBreak.Add

but it doesnt work. I have tried chaing the above code but still says that it doesnt support that method..


Your help is much appreciatte it. Thanks in advance

 

[danevarez]

Hello,
I'm having the exact same problem as you. I want to reset and add new page breaks in a new worksheet that is created from VBA code in Access.

Did you ever figure out how to?