Page Length
 

I am trying to set up Excel to print a 5 1/2" continuous form
(length). Unfortunately the page size = statement is for a 5 1/2"
wide form (not length / height).

Just for fun I tried Word's PageHeight =
Application.InchesToPoints(5.5) setting but wasn't surprised when that
didn't work.

Excel is an excellent application for populating a form using
drop-down boxes, option buttons, etc. but unfortunately is not very
flexible in page setup options. It has been suggested that I use
Word's mailmerge function but I want to keep this application as
simple and easy to use as possible. I would appreciate any
suggestions or ideas anyone may have.

Ernie

Page Length
 

Thanks Eddie. Your solution is something I never heard of... simple
and sweet! I'll give it a shot today and hopefully it will work.

Ernie

On Thu, 7 Aug 2003 15:01:53 +0800, "Eddy"
wrote:

I supposed if you have continuous form, you must be using some type of dot
matrix printer. You will most likely get it to work if you create a new
"Form" for your printer.

Create New Form in Win 2000:
1) Go to Start/Settings/Printer
2) File / Server Properties
3) Check "Create New Form"
4) Type in the size of your form
5) Save the form

"Ernie Moshurchak" ?????
ws.com...
I am trying to set up Excel to print a 5 1/2" continuous form
(length). Unfortunately the page size = statement is for a 5 1/2"
wide form (not length / height).

Just for fun I tried Word's PageHeight =
Application.InchesToPoints(5.5) setting but wasn't surprised when that
didn't work.

Excel is an excellent application for populating a form using
drop-down boxes, option buttons, etc. but unfortunately is not very
flexible in page setup options. It has been suggested that I use
Word's mailmerge function but I want to keep this application as
simple and easy to use as possible. I would appreciate any
suggestions or ideas anyone may have.

Ernie

Page Length
 

Implemented your solution today and it worked like a charm. On
researching the problem, I came across quite a number of requests for
help with similar problems including using Excel to print a continous
label. Hopefully these individuals will find this article if they
arre still having problems. Thanks again.

Ernie

On Thu, 07 Aug 2003 13:19:23 GMT, Ernie Moshurchak
wrote:

Thanks Eddie. Your solution is something I never heard of... simple
and sweet! I'll give it a shot today and hopefully it will work.

Ernie

On Thu, 7 Aug 2003 15:01:53 +0800, "Eddy"
wrote:

I supposed if you have continuous form, you must be using some type of dot
matrix printer. You will most likely get it to work if you create a new
"Form" for your printer.

Create New Form in Win 2000:
1) Go to Start/Settings/Printer
2) File / Server Properties
3) Check "Create New Form"
4) Type in the size of your form
5) Save the form

"Ernie Moshurchak" ?????
ews.com...
I am trying to set up Excel to print a 5 1/2" continuous form
(length). Unfortunately the page size = statement is for a 5 1/2"
wide form (not length / height).

Just for fun I tried Word's PageHeight =
Application.InchesToPoints(5.5) setting but wasn't surprised when that
didn't work.

Excel is an excellent application for populating a form using
drop-down boxes, option buttons, etc. but unfortunately is not very
flexible in page setup options. It has been suggested that I use
Word's mailmerge function but I want to keep this application as
simple and easy to use as possible. I would appreciate any
suggestions or ideas anyone may have.

Ernie