Re: Page Break in Excel from VB 2005

Seth,

The page break is now working, thanks.

I'm going to start to move the public variables. Is there a reason not to keep them there? It seems so much easier:)

The reason I did not have the spread*** visible is because this program is going to run a couple hundred times in a day and the time to open and close excel itself would be very time consuming. After each run an E-mail is created with the XLSX and the PDF. You mention a possible memory leak. Is that a normal concern here?

I did not post the entire program because it is almost 2000 lines long. The generate lines rountine has many sub routines.

Once again thanks for you efforts. I just can't believe I struggled so long with what should be something simple like a page break. I'm doing all kinds of conditional fomratting, etc. without an issues. I guess my first VB program is more of a learning experience. I've been writing COBOL programs forever:)

Thanks,
Steve
"rowe_newsgroups" <rowe_email@xxxxxxxxx> wrote in message news:1184100961.973490.262380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
The generate_rtn is a routie that checks a line counter and based on the
value calls another routine. I have around 40 lines in a text file that is
being created from another program and I build rows in the spread*** based
on the lines in the text file.

You'll need to add the line counter back then and pass it as a
parameter to the Generate_Report method. I removed it as I didn't see
the point to it at the time (though I guessed it had something to do
with the Generate_Report method)

Thanks,

Seth Rowe



.