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 spreadsheet 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_newsgroup s" <ro********@yah oo.comwrote in message
news:11******** **************@ w3g2000hsg.goog legroups.com...
>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 spreadsheet
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